SELECT areaName FROM area ORDER BY CONVERT ( areaName USING gbk ) COLLATE gbk_chinese_ci ASC
说明:
MySQL根据汉字首字母排序
原文:https://www.cnblogs.com/zhaoxxnbsp/p/14693358.html