SELECT * FROM table where (INET_ATON("127.0.1.2") BETWEEN INET_ATON(ipstart) AND INET_ATON(ipend));MySQL查询IP地址是否在某个区间
发表评论
SELECT * FROM table where (INET_ATON("127.0.1.2") BETWEEN INET_ATON(ipstart) AND INET_ATON(ipend));