MySQL按拼音首字母排序

若数据表tbl的某字段name的字符编码是utf8_general_ci

SELECT name FROM `tbl` WHERE 1 ORDER BY CONVERT(name USING gbk) COLLATE gbk_chinese_ci ASC

以上内容转载自：/zhichao2001/article/details/11721325