mysql按拼音首字母排序: select areaName from area order by convert(areaName USING gbk) COLLATE gbk_chinese_ci asc 说明:area为表名,areaName为列名