The examples were created with the MyWAY SQL manager: Download
How to use the INET6_NTOA() function in MySQL and MariaDB databases
In MySQL and MariaDB the INET6_NTOA() function is used to convert an IPv6 address from its numeric representation to its textual form. The function takes a binary string representing the numeric IPv6 address as an argument and returns the corresponding IPv6 address in text format, for example for display purposes or to use in queries and to use comparisons where specific ranges of IPv6 addresses can be filtered or retrieved. String operations can also be performed in this way, or certain parts of the address can be extracted.
Further MySQL und MariaDB SQL Miscellaneous functions