· 10 years ago · Aug 30, 2016, 04:20 PM
1// table definition
2CREATE TABLE IF NOT EXISTS `IP_BlackList` (
3 `ip` varchar(50) NOT NULL,
4 `mask` int(11) NOT NULL DEFAULT '32',
5 PRIMARY KEY (`ip`,`mask`)
6) ENGINE=MyISAM DEFAULT CHARSET=latin1;
7
8// query for checking
9SELECT EXISTS(SELECT `ip` FROM `IP_BlackList` WHERE INET_ATON( '1.2.3.4' ) & ( -1 << 32 - `Mask` ) = INET_ATON( `ip` ) LIMIT 1)