I'm try to sort a column in mysql db that contains numbers, letters and dots.
It should sort to:
How do i do that? A normal ORDER BY would not work with the .30 and .3
The column type is VARCHAR. I tried looking at the mysql doc, and some user comments suggested SOUNDEX and ORD but it doens't seem to work for me. Any ideas?