Syntax
INET_ATON(expr)
Purpose
Converts an IPv4 network address in string format to an integer that represents the address value in network byte order (big-endian). If the input parameter is invalid, it returns NULL.
Notice
Use the INT UNSIGNED data type to store values generated by the INET_ATON() function. Do not use the INT data type with a signed attribute. If you use a signed INT column, the value cannot be correctly stored when the first octet of the IP address is greater than 127.
Examples
obclient> SELECT INET_ATON('1.1.1.1');
+----------------------+
| INET_ATON('1.1.1.1') |
+----------------------+
| 16843009 |
+----------------------+
1 row in set