1.直接用加法
字符串+0
example:
select * from orders order by (column+0) desc
2.使用函数
CAST(column as type);
CONVERT(column, type);
注:
这里的type可以为:
浮点数 : DECIMAL
整数 : SIGNED
无符号整数 : UNSIGNED
example:
select * from orders order by CONVERT(column,SIGNED) desc
select * from orders order by CAST(column as SIGNED) desc