Mysql> Select Inet_aton (' 192.168.202.12 '); +-----------------------------+| Inet_aton (' 192.168.202.12 ') |+-----------------------------+| 3232287244 |+-----------------------------+1 row in Set (0.00 sec) 2, IP converted from data to point form mysql> Select Inet_ Ntoa (' 3232287244 '); +-------------------------+| Inet_ntoa (' 3232287244 ') |+-------------------------+| 192.168.202.12 |+-------------------------+1 row in set (0.08 SEC) I often forget the specific wording of this function, hehe ~ Give a little tip to remember this function, as follows: Inet_aton (): Can be understood as I (P) net_a (ddress) ton (umeric) separate is      IP Network (NET) address converted to digital (numeric) i net_ a to n instead! Hope to help you! O (∩_∩) o~
Mysql:ip address Translation (conversions between common IP address numbers)