mysqlIP查询问题
数据库数据
+-----+----------------+--------------+------------------+----------------+
+_id__+____username____+____regmail___+____finallyIP_____+____finllyTime__+
+-----+----------------+--------------+------------------+----------------+
+_1___+____zhangdin____+_san@163.com__+__192.168.0.123___+____2011-11-01__+
+-----+----------------+--------------+------------------+----------------+
+_2___+____zhangsan____+_san@163.com__+__192.168.11.13___+____2011-11-01__+
+-----+----------------+--------------+------------------+----------------+
+_3___+____lisi________+_san@163.com__+__192.168.215.1___+____2011-11-01__+
+-----+----------------+--------------+------------------+----------------+
+_4___+____huangydn____+_san@163.com__+__192.201.21.23___+____2011-11-01__+
+-----+----------------+--------------+------------------+----------------+
+_5___+____teshdnd_____+_san@163.com__+__192.56.21.123___+____2011-11-01__+
+-----+----------------+--------------+------------------+----------------+
+_6___+____zhasdfsd____+__san@163.com_+__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