Difference between revisions of "mysql"

From S23Wiki
Jump to: navigation, search
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>

  1. 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);