IPV4_STRING_TO_NUM

Converts an IPv4 address to a 32-bit integer.

Syntax

IPV4_STRING_TO_NUM ( <ip> )

Arguments

Arguments	Description
<ip>	a dotted-quad IP address string, eg “1.2.3.4”

Return Type

Integer

Examples

SELECT ipv4_string_to_num('1.2.3.4');
+-------------------------------+
| ipv4_string_to_num('1.2.3.4') |
+-------------------------------+
|                      16909060 |
+-------------------------------+

SELECT ipv4_string_to_num('127.0.0.1');
+---------------------------------+
| ipv4_string_to_num('127.0.0.1') |
+---------------------------------+
|                      2130706433 |
+---------------------------------+