Syntax
IS_IPV4_MAPPED(expr)
Purpose
You can call this function to convert a numeric IPv6 address to a binary string. It returns 1 if the argument is a valid IPv4-mapped IPv6 address, and returns 0 if otherwise. An IPv4-mapped IPv6 address is in the format of ::ffff:ipv4_address.
Examples
obclient> SELECT IS_IPV4_MAPPED(INET6_ATON('::10.0.5.9'));
+------------------------------------------------+
| IS_IPV4_MAPPED(INET6_ATON('::10.0.5.9'))|
+------------------------------------------------+
0 0 0 0 0 0 0
+------------------------------------------------+
1 row in set