mysql 不同数据 个数,查找数字是否在MySQL数据库中不同字段中的两个数字之间

How would you format a query on a MySQL database via PHP to find if an IP address falls between two numbers in two different fields?

Numerical representation of IP address to find:

1265631252

Database format:

IP FROM IP TO REGISTRY ASSIGNED CTRY CNTRY COUNTRY

"1265631232","1265893375","arin","1152835200","US","USA","United States"

"1265893376","1265958911","arin","1149120000","US","USA","United States"

"1265958912","1266024447","arin","1149120000","US","USA","United States"

"1266024448","1266089983","arin","1162425600","US","USA","United States"

解决方案

A query like this:

SELECT * FROM your_table WHERE 1265631252 BETWEEN `IP FROM` AND `IP TO`;

Will return the row(s) for which the supplied number is between IP FROM and IP TO.