How to sort?

Databases
1

Hello,

I have a varchar field in which there is text like:

100 x 150
50 x 25
76 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 ?

Thanks.

2

use two columns, and make them numeric

VARCHAR sorts alphabetically, starting at the leftmost character