解决:
在不修改原有设计的情况下,只能改SQL了,我们需要先把字符串转数字。
字符串转数字的三种方式:
(1)+0
(2)用函数CAST(value as type)或CONVERT(value, type)
- order by (serial_number+0) desc
type可为DECIMAL (浮点数 )、SIGNED(整数)、UNSIGNED (无符号整数 )
- order by CAST(serial_number as SIGNED) desc
- order by CONVERT(serial_number,SIGNED) desc
文章点评