56,687
社区成员
发帖
与我相关
我的任务
分享
mysql> select * from t_yyhakusu;
+--------------+----------------+--------+------------+
| begin_ip | end_ip | add1 | add2 |
+--------------+----------------+--------+------------+
| 194.77.0.0 | 194.77.255.255 | 德国 | 无具体地点 |
| 194.78.99.80 | 194.78.99.95 | 比利时 | BOSTON |
+--------------+----------------+--------+------------+
2 rows in set (0.11 sec)
mysql>
mysql> select * from t_yyhakusu
-> where INET_ATON('194.78.99.85') between INET_ATON(begin_ip) and INET_ATON(end_ip);
+--------------+--------------+--------+---------+
| begin_ip | end_ip | add1 | add2 |
+--------------+--------------+--------+---------+
| 194.78.99.80 | 194.78.99.95 | 比利时 | BOSTON |
+--------------+--------------+--------+---------+
1 row in set (0.11 sec)
mysql>