正常来讲 字符创排序 按照 首个数字排序的

SELECT * FROM `s_dictionary_info`  WHERE  small_type='NATION'  ORDER BY  type_no

 

 

SELECT * FROM `s_dictionary_info`  WHERE  small_type='NATION'  ORDER BY  type_no+0   asc