206
I have numbers saved as VARCHAR to a MySQL database. I can not make them INT due to some other depending circumstances.
It is taking them as character not as number while sorting.
In the database, I have values like these:
1 2 3 4 5 6 7 8 9 10...
But when I sort them by this field I get a result like this:
1 10 2 3 4 5 6 7 8 9
How can I make it get results ordered numerically, ascending?