vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 |