mysql查询结果按照中文字典顺序排序
SELECT *
FROM t_exam t
WHERE t.department_id = '1'
ORDER BY CONVERT(exam_name USING gbk) ASC
FROM t_exam t
WHERE t.department_id = '1'
ORDER BY CONVERT(exam_name USING gbk) ASC

浙公网安备 33010602011771号