例如grid_name字段需要排序成网格1 网格2 …网格87…
SQL
ORDER BY length(字段) ASC,
或者:
SELECT id,排序字段
FROM 表名
ORDER BY CAST(TRIM('中文' FROM 排序字段) AS SIGNED)
例如grid_name字段需要排序成网格1 网格2 …网格87…
SQL
ORDER BY length(字段) ASC,
或者:
SELECT id,排序字段
FROM 表名
ORDER BY CAST(TRIM('中文' FROM 排序字段) AS SIGNED)