Sometimes you have to store numbers in text format. This is not a good practice, but sometimes there is no other option.

When you perform an “order by” this field,you can get something like this:

1
10
11
111
12
2
20
3

Continue reading “[Trick] MySQL – Order string as number” »