landysaccount Posted September 23, 2009 Share Posted September 23, 2009 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. Link to comment https://forums.phpfreaks.com/topic/175229-sorting-number-values-with-phpmysql/ Share on other sites More sharing options...
PFMaBiSmAd Posted September 23, 2009 Share Posted September 23, 2009 Use - ORDER BY INET_ATON(ip) Link to comment https://forums.phpfreaks.com/topic/175229-sorting-number-values-with-phpmysql/#findComment-923582 Share on other sites More sharing options...
fenway Posted October 2, 2009 Share Posted October 2, 2009 Better yet, store these properly as UNSIGNED INTs. Link to comment https://forums.phpfreaks.com/topic/175229-sorting-number-values-with-phpmysql/#findComment-929245 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.