参考
https://www.cnblogs.com/baby123/p/11716896.html
1.直接使用
select * from orders order by (mark+0) desc
2.使用函数
CAST(value as type);
CONVERT(value, type);
注:
这里的type可以为:
浮点数 : DECIMAL
整数 : SIGNED
无符号整数 : UNSIGNED
select * from orders order by CONVERT(mark,SIGNED) desc
select * from orders order by CAST(mark as SIGNED) desc