在MySQL数据库的不同字段中查找数字是否在两个数字之间 [英] Find if number is between two numbers in different fields in a MySQL database

问题描述

您将如何通过PHP在MySQL数据库上设置查询格式，以查找IP地址是否位于两个不同字段中的两个数字之间?

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?

要查找的IP地址的数字表示形式

Numerical representation of IP address to find:

1265631252

数据库格式:

 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"

推荐答案

这样的查询:

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

将返回提供的数字在IP FROM和IP TO之间的行.

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

这篇关于在MySQL数据库的不同字段中查找数字是否在两个数字之间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！