Search code examples
mysqlsqlcastingintegervarchar

MySQL ORDER chars numerically


I want to order this column which is a varchar value in mysql

13.25 
10
8.99
18.25
order by column asc

tankyou


Solution

  • Order By CAST(colName AS DECIMAL(10,2)) ASC