MySQL IPv4 IPv6

How can I use a MySQL method rather than a script to judge?INET6_ATON(expr)

Https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-functions.html#function_inet-aton

Https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-functions.html#function_inet6-aton

Given an IPV6 or IPV4 network address as a string, returns a binary string that represents the numeric value of the Addres s in network byte order (big endian). Because Numeric-format IPv6 addresses require more bytes than the largest integer type, the representation returned by Thi s function has the VARBINARY data type: For VARBINARY(16) IPv6 addresses and for VARBINARY(4) IPV4 addresses. If The argument is not a valid address, INET6_ATON() returns NULL .

The following examples use to HEX() display the INET6_ATON() result in printable form:

MySQL IPv4 IPv6