Sorting goes only by the first character, how to fix it?

Question

SQL

$rez = mysqli_query($database_connect, "SELECT * FROM `mytable2` ORDER BY `3` DESC");

in column 3 there are numbers from 1 to 100. and for example the number 5 is higher in the search than 49. Sorting goes only by the first character, how to fix this?

Answer 1

Column type - CHAR (VARCHAR)?

... ORDER BY col + 0 DESC

... ORDER BY CAST(col AS int)  DESC