SELECT ISINRANGE( '172.16.1.132', '172.16.1.19', '172.16.1.154' );
SELECT ISINRANGE( '172.16.1.132', '172.16.1.19-172.16.1.154' );
SELECT ISINRANGE( '172.16.1.132', '172.16.1.154', '172.16.1.19' );
SELECT ISINRANGE( '172.16.1.132', '172.16.1.154-172.16.1.19' );
-- 	==> 1
SELECT ISINRANGE( '172.16.1.132', '172.16.1.19', '172.16.1.132' );
SELECT ISINRANGE( '172.16.1.132', '172.16.1.19-172.16.1.132' );
SELECT ISINRANGE( '172.16.1.132', '172.16.1.132', '172.16.1.19' );
SELECT ISINRANGE( '172.16.1.132', '172.16.1.132-172.16.1.19' );
-- 	==> 1
SELECT ISINRANGE( '172.16.1.132', '10.0.0.19', '10.255.254.132' );
SELECT ISINRANGE( '172.16.1.132', '10.0.0.19-10.255.254.132' );
SELECT ISINRANGE( '172.16.1.132', '10.0.0.132', '10.255.254.19' );
SELECT ISINRANGE( '172.16.1.132', '10.0.0.132-10.255.254.19' );
-- 	==> 0
SELECT ISINRANGE( '172.16.1.193', '172.14.1.0', '198.23.43.17' );
SELECT ISINRANGE( '172.16.1.193', '172.14.1.0-198.23.43.17' );
SELECT ISINRANGE( '172.16.1.193', '198.23.43.17', '172.14.1.0' );
SELECT ISINRANGE( '172.16.1.193', '198.23.43.17-172.14.1.0' );
-- 	==> 1

CREATE TABLE ip_add (
        ip      varchar( 15 )
);
INSERT INTO ip_add VALUES('172.16.1.40');
INSERT INTO ip_add VALUES('172.16.1.93');
INSERT INTO ip_add VALUES('172.16.1.204');
INSERT INTO ip_add VALUES('172.16.4.203');
INSERT INTO ip_add VALUES('172.16.4.205');
INSERT INTO ip_add VALUES('172.16.4.69');
INSERT INTO ip_add VALUES('10.0.1.204');
INSERT INTO ip_add VALUES('10.0.1.16');
INSERT INTO ip_add VALUES('10.1.0.16');
INSERT INTO ip_add VALUES('192.168.1.5');
INSERT INTO ip_add VALUES('192.168.1.7');
INSERT INTO ip_add VALUES('192.168.1.19');

SELECT ip FROM ip_add WHERE ISINRANGE( ip, '172.16.1.0', '172.16.255.255' );
SELECT ip FROM ip_add WHERE ISINRANGE( ip, '172.16.1.0-172.16.255.255' );
--	172.16.1.40
--	172.16.1.93
--	172.16.1.204
--	172.16.4.203
--	172.16.4.205
--	172.16.4.69

SELECT ip FROM ip_add WHERE ISINRANGE( ip, '172.16.1.0', '172.16.1.230' );
SELECT ip FROM ip_add WHERE ISINRANGE( ip, '172.16.1.0-172.16.1.230' );
--	172.16.1.40
--	172.16.1.93
--	172.16.1.204

SELECT * FROM ip_add WHERE NOT ISINRANGE( ip, '0.0.0.0', '172.16.1.255' );
SELECT * FROM ip_add WHERE NOT ISINRANGE( ip, '0.0.0.0-172.16.1.255' );
-- 172.16.4.203
-- 172.16.4.205
-- 172.16.4.69
-- 192.168.1.5
-- 192.168.1.7
-- 192.168.1.19

DELETE FROM ip_add WHERE NOT ISINRANGE( ip, '30.0.0.0', '200.0.0.0' );
DELETE FROM ip_add WHERE NOT ISINRANGE( ip, '30.0.0.0-200.0.0.0' );

SELECT * FROM ip_add;
--	172.16.1.40
--	172.16.1.93
--	172.16.1.204
--	172.16.4.203
--	172.16.4.205
--	172.16.4.69
--	192.168.1.5
--	192.168.1.7
--	192.168.1.19