Content added Content deleted
imported>mutante mNo edit summary |
imported>DrOwl No edit summary |
||
Line 4:
{{manpage}}
== Usefull hints ==
Just some useful notes from different locations on the internet
=== Sort By IP address ===
From O'Reillys MySQL Cookbook:
SELECT ip FROM hostip
ORDER BY
SUBSTRING_INDEX(ip, '.', 1) + 0,
SUBSTRING_INDEX(SUBSTRING_INDEX(ip, '.', -3), '.', 1) + 0,
SUBSTRING_INDEX(SUBSTRING_INDEX(ip, '.', -2), '.', 1) + 0,
SUBSTRING_INDEX(ip, '.', -1) + 0;
or (MySQL 3.23.15 an above)
SELECT ip FROM hostip
ORDER BY INET_ATON(ip);
|
Latest revision as of 14:25, 30 November 2011
Also see: MySQL
<man>mysql</man>
Usefull hints[edit]
Just some useful notes from different locations on the internet
Sort By IP address[edit]
From O'Reillys MySQL Cookbook:
SELECT ip FROM hostip ORDER BY SUBSTRING_INDEX(ip, '.', 1) + 0, SUBSTRING_INDEX(SUBSTRING_INDEX(ip, '.', -3), '.', 1) + 0, SUBSTRING_INDEX(SUBSTRING_INDEX(ip, '.', -2), '.', 1) + 0, SUBSTRING_INDEX(ip, '.', -1) + 0;
or (MySQL 3.23.15 an above)
SELECT ip FROM hostip ORDER BY INET_ATON(ip);