I often need to sort a set or subset of records in a table in an arbitrary way and am confused about how to get the order I need using a separate sort field.
What I would like to do is sort like this:
Mysql, of course does this:
If I enter a zero before single digits, MYSQL inconveniently deletes it when inserting it into the table.
Any way I can get it to sort like we learned to count in kindergarten?
The only option I have found is to use letters, but then I run into the same problem if I am sorting more than 26 items.
No it doesn't. Unless you've defined the sort order column as character instead of numeric. Try changing the column type.
This topic is now closed. New replies are no longer allowed.