varchar to number conversion for sorting in MySQL

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

Thanks.

Answer 1

Use:

order by cast(column as unsigned) asc

Answer 2

This should work as well:

order by (0 + column) asc

Answer 3

order by cast(column as unsigned) asc

thnx very much