mysql sort string number
mysql
Solution
Use a CAST or a CONVERT function.
Problem
I have a column of type varchar that stores many different numbers. Say for example there are 3 rows: 17.95, 199.95 and 139.95.How can i sort that field as numbers in mysql