1、字段按照中文首字母排序
ORDER BY
CONVERT(字段名 USING gbk) COLLATE gbk_chinese_ci ASC
2、字段按照字母、汉字、数字排序
(
SELECT
*
FROM
数据表
WHERE
ASCII(字段名) <= 122
AND ASCII(字段名) >= 65
ORDER BY
字段名 LIMIT 9999999
)
UNION ALL
(
SELECT
*
FROM
数据表
WHERE
ASCII(字段名) > 122
ORDER BY
CONVERT (字段名 USING GBK) LIMIT 9999999
)
UNION ALL
(
SELECT
*
FROM
数据表
WHERE
ASCII(字段名) < 65
ORDER BY
字段名 LIMIT 9999999
)