====== IPアドレス-アドレスナンバー ======

INET_NTOA
<code console>
mysql> select id,inet_ntoa(ip_number) from ip_addresses;
+------+----------------------+
| id   | inet_ntoa(ip_number) |
+------+----------------------+
| 4611 | 10.10.0.3              | 
+------+----------------------+
1 row in set (0.00 sec)
</code>

逆は
INET_ATON
<code console>
mysql> select INET_ATON('10.10.0.3');
+------------------------+
| INET_ATON('10.10.0.3') |
+------------------------+
|              168427523 | 
+------------------------+
1 row in set (0.08 sec)
</code>