How to convert an IPv6 address from number format to string using the INET6_NTOA() function?

INET6_NTOA(int) is a MySQL built-in function that converts an IPv6 address from number format to string. For example:

SET @ipv6 = UNHEX('FDFE0000000000005A55CAFFFEFA9089');

SELECT HEX(@ipv6), INET6_NTOA(@ipv6);
  -- +----------------------------------+---------------------------+
  -- | HEX(@ipv6)                       | INET6_NTOA(@ipv6)         |
  -- +----------------------------------+---------------------------+
  -- | FDFE0000000000005A55CAFFFEFA9089 | fdfe::5a55:caff:fefa:9089 |
  -- +----------------------------------+---------------------------+

INET6_NTOA also works on IPv4 addresses. For example:

SET @ipv4 = UNHEX('0A000509');

SELECT HEX(@ipv4), INET6_NTOA(@ipv4);
  -- +------------+-------------------+
  -- | HEX(@ipv4) | INET6_NTOA(@ipv4) |
  -- +------------+-------------------+
  -- | 0A000509   | 10.0.5.9          |
  -- +------------+-------------------+

Reference information of the INET6_NTOA() function:

INET6_NTOA(int): ip
  Converts an IPv6 address from number format to string.

Arguments, return value and availability:
  int: Required. The IPv6 address in number format. 
  ip: Return value. The IPv6 address as a string.
  Available since MySQL 4.0.

Related MySQL functions:

• INET_ATON() - IP Address String to Number
• INET_NTOA() - IP Address Number to String
• INET6_ATON() - IPv6 Address String to Number
• INET6_NTOA() - IPv6 Address Number to String

⇒ IS_FREE_LOCK() - Checking Lock Status

⇐ INET6_ATON() - IPv6 Address String to Number

⇑ MySQL Functions for Miscellaneous Purposes

⇑⇑ MySQL Function References