Problem Description
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?
AI-Generated Solution
Powered by LMSouq AI · GPT-4.1-mini
Analyzing problem and generating solution…
Was this solution helpful?