INET6_NTOA
INET6_NTOAβ
INET6_NTOA
descriptionβ
Syntaxβ
VARCHAR INET6_NTOA(VARCHAR ipv6_num)
Takes an IPv6 address in binary format of type String. Returns the string of this address in text format. The IPv4 address mapped by IPv6 starts with ::ffff:111.222.33.
exampleβ
mysql> select inet6_ntoa(unhex('2A0206B8000000000000000000000011')) as addr;
+--------------+
| addr |
+--------------+
| 2a02:6b8::11 |
+--------------+
1 row in set (0.01 sec)
keywordsβ
INET6_NTOA, IP