Sorting number values with php/mysql

[landysaccount]

Hello,

 

I have a table with ip values:

 

172.16.100.10

172.16.100.11

.....

172.16.100.50

172.16.100.51

....

172.16.100.100

172.16.100.102

172.16.100.103

 

and so on....

 

I would like to get a list in ascending order:

 

The ip_address field is a varchar(15);

 

select ip_address as ip from ip where ip_assigned='N' order by ip limit 5;

 

but I get:

 

172.16.100.10

172.16.100.100

172.16.100.101

172.16.100.102

172.16.100.103

 

How can I get a real sort in mysql?

 

Thanks in advaced.

[PFMaBiSmAd]

Use -

 

ORDER BY INET_ATON(ip)

 

[fenway]

Better yet, store these properly as UNSIGNED INTs.