Results 1 to 2 of 2
Thread: Sort order question
Oct 11, 2013, 06:44 #1
- Join Date
- Aug 2007
- 0 Post(s)
- 0 Thread(s)
Sort order question
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.