mysqlIP查询问题

Question

数据库数据
+-----+----------------+--------------+------------------+----------------+
+_id__+____username____+____regmail___+____finallyIP_____+____finllyTime__+
+-----+----------------+--------------+------------------+----------------+
[email protected]__+__192.168.0.123___+____2011-11-01__+
+-----+----------------+--------------+------------------+----------------+
[email protected]__+__192.168.11.13___+____2011-11-01__+
+-----+----------------+--------------+------------------+----------------+
[email protected]__+__192.168.215.1___+____2011-11-01__+
+-----+----------------+--------------+------------------+----------------+
[email protected]__+__192.201.21.23___+____2011-11-01__+
+-----+----------------+--------------+------------------+----------------+
[email protected]__+__192.56.21.123___+____2011-11-01__+
+-----+----------------+--------------+------------------+----------------+
[email protected]_+__192.68.101.23___+____2011-11-01__+
+-----+----------------+--------------+------------------+----------------+现在求一条SQL能够查询出IP段的数据：
比如我要查finallyIP在：127.0.0.1 ~ 192.168.1.1 之间的数据
那么结果应该是
id为1、5、6的数据finallyIP为：
192.168.0.123
192.68.101.23
192.56.21.123 

Answer 1

select * from tt where INET_ATON(finallyIP) between  2130706433 and  3232235777

Answer 2

good
thanks:'wwwwb'