MySQL's varchar fields are sorted by number

MySQL's varchar fields are sorted by number

Today, I encountered a question about sorting, when a table was built, and the wide fields in the table were stored with varchar, because the unit might be stored so it was not stored in Int. But later changed the need to say is not input units, at that time think of anyway can be used also there is no modification of the field type, reserved varchar.

Here's the point:

This is not sorted when the display

Now put it in ascending order

found that the problem of sorting, 1000 in front of 120, to solve this problem only need to convert the type on the line, the sort of field +0 can be converted

Sql:

Select rule from Th_steel order by rule+0 ASC;

You can also use the MySQL function to handle

MySQL's varchar fields are sorted by number