We can look at this and see that .11 should sort after .2, but I'm not sure how to tell SQL to sort a text field like that.<BR><BR>Is it possible? Thanks! More options ...

SQL isn't picky about how it returns data to you, based on your queries. It will simply return the relevant table rows in the order in which they exist in the table. This is often insufficient for the ...

SQL itself doesn't support a proper sorting as well. But there is a solution as follows: SELECT * FROM module_version ORDER BY INET_ATON(SUBSTRING_INDEX(CONCAT(version,'.0.0.0'),'.',4)); - we are ...