SEO

On Tue, 29 Apr 2008 19:26:39 +0200, Manhattan Project
<efake@xxx.poczta.fm> wrote:
> I wonder how should I select and order IP addresses from table to get
> "natural" IP order - it means
> 10.0.0.1
> 10.0.0.2
> 10.0.0.11
> not like it is in case of "ORDER BY IP"
> 10.0.0.1
> 10.0.0.11
> 10.0.0.2

SELECT ip
FROM tablename
ORDER BY INET_ATON(ip)

http://dev.mysql.com/doc/refman/5.0/...tion_inet-aton
--
Rik Wasmus

Hi,

I wonder how should I select and order IP addresses from table to get
"natural" IP order - it means
10.0.0.1
10.0.0.2
10.0.0.11
not like it is in case of "ORDER BY IP"
10.0.0.1
10.0.0.11
10.0.0.2

Thx in advance