MySQL ORDER by sort problem

Reference Blog http://blog.csdn.net/hollboy/article/details/13296601

The sort of MySQL order by has encountered a problem today

The scenario is that the sorted field is set to a varchar type, and then the sort is not in the order of the largest to the smaller

According to the order in the diagram should be the positive sequence, 9 rows at the top, but actually 666 rows at the top

One way to solve this problem

The actual situation is to start by the leftmost first sort and then in a comparison, here in the SQL when the solution can be added 0, or the front plus--also can OH

The second solution

Change the field type to int type see below

The sorting is correct immediately, and the position is on the right, and may also be sorted by the number on the right, and the time type is no longer described.

MySQL ORDER by sort problem