To convert a network address to a numeric value, use INET_ATON() function: INET_ATON() : INET_ATON « Function « SQL / MySQL






  1. SQL / MySQL
  2. Function
  3. INET_ATON

To convert a network address to a numeric value, use INET_ATON() function: INET_ATON()

     
mysql>
mysql> SELECT INET_ATON('127.0.0.1');
+------------------------+
| INET_ATON('127.0.0.1') |
+------------------------+
|             2130706433 |
+------------------------+
1 row in set (0.00 sec)








Related examples in the same category

1.Sort the IP values using the INET_ATON( ) function, which converts a network address directly to its underlyin
2.Convert network integer to an IP address by using the following function: INET_NTOA()