SELECT
REPLACE (age, '岁', '') AS age
FROM
age
ORDER BY
cast(
REPLACE (age, '岁', '') AS SIGNED INTEGER
)
思路:先替换中文字符,然后转int排序
SELECT
REPLACE (age, '岁', '') AS age
FROM
age
ORDER BY
cast(
REPLACE (age, '岁', '') AS SIGNED INTEGER
)
思路:先替换中文字符,然后转int排序