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