INET_ATON Function

Description

The INET_ATON function receives the string of an IP address and returns a number. When an IPv4 address string such as 'a.b.c.d' is entered, the function returns a x 256³ + b x 256² + c x 256 + d. The return type is BIGINT.

Syntax

INET_ATON( ip_string )

• ip_string: IPv4 address string

Example

In the following example, 192.168.0.10 is calculated as 192 x 256³ + 168 x 256² + 0 x 256 + 10.

SELECT INET_ATON('192.168.0.10');

 

   inet_aton('192.168.0.10')

============================

                  3232235530