I have a varchar field in which there is text like:
100 x 15050 x 2576 x 51
I want to sort it. But when i put ORDER BY it then shows 100 first then 50 and then 76
How to make it so it shows 50, 76 and then 100 ?
use two columns, and make them numeric
VARCHAR sorts alphabetically, starting at the leftmost character