The examples were created with the MyWAY SQL manager: Download
How to use the INET6_ATON() function in MySQL and MariaDB databases
In MySQL and MariaDB the INET6_ATON() function is used to convert an IPv6 address from its text representation to a numeric form. The function takes an IPv6 address in its text format as an argument and returns a binary string representing the numeric value of the IPv6 address, suitable for storage in a binary table columns (BINARY, VARBINARY, BLOB) or in comparisons or queries to filter or retrieve specific ranges of IPv6 addresses can be used. By converting IPv6 addresses to their numeric form, calculations or operations can be performed on them, for example to create subnets or extract certain parts of the address.
Further MySQL und MariaDB SQL Miscellaneous functions