mysql 使用inet_aton和inet_ntoa处理ip地址数据

来源：互联网发布：js动态修改style属性编辑：程序博客网时间：2024/05/18 16:17

创建表CREATE TABLE `user` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `ip` int(10) unsigned NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB;
插入几条数据INSERT INTO `user` (`id`, `name`, `ip`) VALUES(2, 'Abby', inet_aton('192.168.1.1')),(3, 'Daisy', inet_aton('172.16.11.66')),(4, 'Christine', inet_aton('220.117.131.12'));
查询显示为电地址mysql> select id,name,inet_ntoa(ip) as ip from `user`;+----+-----------+----------------+| id | name      | ip             |+----+-----------+----------------+|  2 | Abby      | 192.168.1.1    ||  3 | Daisy     | 172.16.11.66   ||  4 | Christine | 220.117.131.12 |+----+-----------+----------------+
比较方法如果需要找出在某个网段的用户（例如：172.16.11.1 ~ 172.16.11.100)，可以利用PHP的ip2long方法，把ip地址转为整型，再进行比较。mysql> select ip,name,inet_ntoa(ip) as ip from `user` where ip>=2886732545 and ip<=2886732644;+------------+-------+---------------+| ip         | name  | ip            |+------------+-------+---------------+| 2886732610 | Daisy | 172.16.11.66  |+------------+-------+---------------+


查看原文：http://newmiracle.cn/?p=1575

0 0