Given the dotted-quad representation of a network address as a string, returns an integer that represents the numeric value of the address. Addresses may be 4- or 8-byte addresses.
The generated number is always in network byte order. For the example just shown, the number is calculated as 209×2563 + 207×2562 + 224×256 + 40.
INET_ATON() also understands short-form IP addresses:
SELECT INET_ATON('127.0.0.1'), INET_ATON('127.1');
-> 2130706433, 2130706433
When storing values generated by
INET_ATON(), it is recommended that you use an
INT UNSIGNED column. If you use a (signed)
INT column, values corresponding to IP addresses for which the first octet is greater than 127 cannot be stored correctly. See Section 10.2, "Numeric Types".
- To match a exact given IP range
- select * from Customer_IP where
INET_ATON(IP_End)>=INET_ATON('18.104.22.168′) and INET_ATON(IP_Start)<=INET_ATON('22.214.171.124′)
Given a numeric network address (4 or 8 byte), returns the dotted-quad representation of the address as a string.