ip格式:1.1.1.2
IP段格式:1.1.1.1/128
SELECT ipRange, SUBSTRING_INDEX(ipRange, '/', 1) startip, CONCAT(SUBSTRING_INDEX(ipRange, '.', 3), '.' ,SUBSTRING_INDEX(ipRange, '/', -1)) endip
FROM sm_ip
WHERE INET_ATON('0.0.0.2') BETWEEN INET_ATON(SUBSTRING_INDEX(ipRange, '/', 1)) AND INET_ATON(CONCAT(SUBSTRING_INDEX(ipRange, '.', 3), '.' ,SUBSTRING_INDEX(ipRange, '/', -1)))