Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

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.

Info
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 |
+----------------------------------------------+

Related Topics