varchar类型ORDER BY按字符串排序,如下图
若想按数字大小排序,ORDER BY 的字段 + 0即可
示例:
SELECT
request_number,
created
FROM
asset_recovery_detail
ORDER BY
request_number + 0 ASC
效果如下:
varchar类型ORDER BY按字符串排序,如下图
若想按数字大小排序,ORDER BY 的字段 + 0即可
示例:
SELECT
request_number,
created
FROM
asset_recovery_detail
ORDER BY
request_number + 0 ASC
效果如下: