Varchar to number conversion for sorting

Question

I have a query ordered by column:

select * from mytable order by column asc — sort table 

column type is varchar, so the output is:

1 10 100 11 12 13 

How should I sort if I want them to sort by numeric value so the output is:

1 10 11 12 13 100 

Answer 1

Use:

order by cast(column as unsigned) asc