I am creating an IP inventory database.

On a select query when i try to "oreder by" the ip address it doesn't sort correctly.

if you have the IP addresses in the this format : 172.016.007.020 it sorts fine.

But i would like to be able to view and enter in new IP's in this format:
172.16.7.20

Any clues?
thanks very much
Noam

Why not try to use hexa format to sort ip adresse ?

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



Willi :-)