利用MySql内置函数对IP进行排序
Submitted by PCplayer on 2007, June 4, 9:35 AM. 纯属闲聊
INET_ATON(expr)
Given the dotted-quad representation of a network address as a string, returns an integer that represents the numeric value of the address. Addresses may be 4- or 8-byte addresses.
mysql> SELECT INET_ATON('209.207.224.40');
-> 3520061480
The generated number is always in network byte order. For the example just shown, the number is calculated as 209×2563 + 207×2562 + 224×256 + 40.
INET_ATON() also understands short-form IP addresses:
mysql> SELECT INET_ATON('127.0.0.1'), INET_ATON('127.1');
-> 2130706433, 2130706433
Note: When storing values generated by INET_ATON(), it is recommended that you use an INT UNSIGNED column. If you use a (signed) INT column, values corresponding to IP addresses for which the first octet is greater than 127 cannot be stored correctly. See Section 11.2, “Numeric Types”.
INET_NTOA(expr)
Given a numeric network address (4 or 8 byte), returns the dotted-quad representation of the address as a string.
mysql> SELECT INET_NTOA(3520061480);
-> '209.207.224.40'
以上是Mysql手册中的说明，下面用实例来说明如何用这些函数进行排序
假设ip是以字符串形式存储在表table_device的device_ip字段中，则以下这句可以返回以ip排序的结果
select device_ip from table_device order by inet_aton(device_ip)
结果：
192.168.0.1
192.168.0.51
92.168.0.111
92.168.0.223
Tags: mysql
« 上一篇 | 下一篇 »
Trackbacks
361条记录访客评论
wowgold300.com is a leading provider of services tailored to the needs of MMORPG players who want to maximize their online gaming experience. wowgold300 dot com is best! ve5cw7fA
Post by wowgold300 on 2009, June 12, 6:20 AM 
#1
镜面触摸屏 联想智能手机ET660仅1299 Rjco0U1v
Post by 触摸屏 on 2009, June 12, 10:06 AM #2
寒窗苦读十余载,只为当个代孕妈妈? Z6IRiinl
Post by 代孕 on 2009, June 13, 4:45 AM #3
很不错的说 小女子先收藏了
Post by only4game on 2009, June 13, 12:19 PM #4
leadingGOOGLE优化Company VjesQSml
Post by google优化 on 2009, June 14, 3:06 AM #5
呵呵 有点意思 下班回家再来看
Post by power4leveling on 2009, June 14, 8:16 AM #6
今年夏天流行羽毛球培训和网球培训2009061401 NOuWnG00
Post by 羽毛球培训 on 2009, June 15, 2:29 AM #7
最近工作有点累,看看你的文章可以让人忘记烦恼~ 交个朋友吧
Post by goleveling on 2009, June 15, 2:38 PM #8
您的GOOGLE推广吮的名列前茅十个原因
Post by google推广 on 2009, June 15, 6:49 PM #9
广东省洒水车汽车起重机高空作业车招标公告
Post by 高空作业车 on 2009, June 15, 7:00 PM #10
用于销售人员、客户及产品进销存的日常管理
Post by 进销存 on 2009, June 15, 7:04 PM #11
全硅溶胶精密铸造企业,主要产品:精密铸造,不锈钢首饰,刀具配件,盲道钉,工业零件等,主要材质
Post by 精密铸造 on 2009, June 15, 7:17 PM #12
本届展会还将成为全国名厨、知名咖啡师、调酒师的最高竞技舞台
Post by 调酒 on 2009, June 15, 7:18 PM #13
到天涯来吧讨论网球培训
Post by 网球培训 on 2009, June 15, 8:58 PM #14
搜索引擎营销和SEO总是非常动态领域。 查寻引擎做变动全部时间。 他们某时宣布他们的变动，我们有时听任在他们的猜测。 无论如何，多半，我们主要留下给我们自己的设备
Post by seo on 2009, June 16, 1:50 PM #15
到天涯来吧讨论婚纱摄影 wQnGsHzz
Post by 婚纱摄影 on 2009, June 16, 11:42 PM #16
派咸蛋超人去协助未来战士！
Post by wow-gold-powerleveli on 2009, June 17, 3:41 PM #17
GABIONS
Post by GABIONS on 2009, June 18, 5:03 AM #18
玻璃检测仪器
Post by 玻璃检测仪器 on 2009, June 18, 5:08 AM #19
Molecular Sieve
Post by Molecular on 2009, June 18, 5:34 AM #20
发表评论
