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