Home >Database >Mysql Tutorial >mysql如何根据汉字首字母排序_MySQL
mysql如何根据汉字首字母排序_MySQL
- WBOYOriginal
- 2016-06-01 13:18:121269browse
bitsCN.com
select areaName from area order by convert(areaName USING gbk) COLLATE gbk_chinese_ci asc
说明：areaName为列名
area为表名bitsCN.com
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：MySQL Hash索引和B-Tree索引的区别_MySQLNext article：MySQLCluster7.2.15安装部署性能测试_MySQL