MySQL Tutorial/Miscellaneous Functions/INET ATON
INET_ATON() also understands short-form IP addresses
<source lang="sql">
mysql> mysql> SELECT INET_ATON("127.0.0.1"), INET_ATON("127.1"); +------------------------+--------------------+ | INET_ATON("127.0.0.1") | INET_ATON("127.1") | +------------------------+--------------------+ | 2130706433 | 2130706433 | +------------------------+--------------------+ 1 row in set (0.00 sec) mysql></source>
INET_ATON(expr): Given a network address, returns an integer that represents the numeric value of the address.
The generated number is always in network byte order.
The number is calculated as 68*256^3 + 207*256^2 + 224*256 + 40.
<source lang="sql">
mysql> mysql> SELECT INET_ATON("68.207.224.40"); +----------------------------+ | INET_ATON("68.207.224.40") | +----------------------------+ | 1154474024 | +----------------------------+ 1 row in set (0.00 sec) mysql> mysql></source>