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 database I have
1 2 3 4 5 6 7 8 9 10...
On my page it shows ordered list like this:
1 10 2 3 4 5 6 7 8 9
How can I make it appear ordered by numbers ascending?