Mysql

Also see: MySQL

mysql

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