Ok, i am trying to “ORDER by” in a MySQL select statement. I would like to load a certain column with numbered filenames(e.g:1.jpg,2.jpg,3.jpg…) but in order.
It is sorting them 1,10,11,11,…2,20,22,23,…3…you get the idea. If this was just a number i would “ORDER BY CONVERT(path, DECIMAL) ASC” my problems away, but i need to do this to a vchar column.
Any ideas?[whisper]bwh2?;)[/whisper]
