MySql 求一条Sql写法
数据库数据
-----+----------------+--------------+------------------+----------------+
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