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