mysql字符串类型的数字如何排序

对字符串姓数字进行数学操作

1、字符串型数字+0

select * from table order by field+0 desc

2、字符串型数字*1

select * from table order by field*1 desc