mysql查询结果按照中文字典顺序排序

SELECT *
FROM t_exam t
WHERE t.department_id = '1'
ORDER BY CONVERT(exam_name USING gbk) ASC
posted @ 2019-12-13 08:36  半湖思絮  阅读(1004)  评论(0编辑  收藏  举报