INET_ATON
Converts an IPv4 address to a 32-bit integer.
Syntax
INET_ATON ( ip )
Arguments
ip: a dotted-quad IP address, eg “1.2.3.4”
Return Type
Integer, or NULL if the IP address cannot be parsed.
Note
This function does not handle IPv6 addresses.
Examples
SELECT INET_ATON('1.2.3.4');
****
+----------------------+
| INET_ATON('1.2.3.4') |
+----------------------+
| 16909060 |
+----------------------+
SELECT INET_ATON('127.1');
****
+--------------------+
| INET_ATON('127.1') |
+--------------------+
| 2130706433 |
+--------------------+SELECT INET_ATON('127.0.0.1');
****
+------------------------+
| INET_ATON('127.0.0.1') |
+------------------------+
| 2130706433 |
+------------------------+SELECT INET_ATON('2a03:2880:10:1f02:face:b00c::25');
****
+----------------------------------------------+
| INET_ATON('2a03:2880:10:1f02:face:b00c::25') |
+----------------------------------------------+
| NULL |
+----------------------------------------------+