MySQL根据汉字首字母排序

SELECT
	areaName 
FROM
	area 
ORDER BY
	CONVERT ( areaName USING gbk ) COLLATE gbk_chinese_ci ASC

说明:

  • areaName为列名
  • area为表名