Content added Content deleted
imported>mutante m (merged with MySQL) |
imported>DrOwl No edit summary |
||
(One intermediate revision by one other user not shown) | |||
Line 1: | Line 1: | ||
Also see: [[MySQL]] |
|||
<man>mysql</man> |
|||
{{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);