Difference between revisions of "mysql"
From S23Wiki
m |
|||
Line 4: | Line 4: | ||
{{manpage}} | {{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 06:25, 30 November 2011
Also see: MySQL
<man>mysql</man>
- redirect Template: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);