运维网's Archiver
论坛
›
MySQL运维
› mysql 按拼音首字母排序的查询语句
ykwll
发表于 2016-10-21 00:14:41
mysql 按拼音首字母排序的查询语句
数据表某字段client_name的字符编码是utf8_general_ci;
SELECT*FROM`client_info_msg` ORDER BY CONVERT( client_name USING gbk ) COLLATE gbk_chinese_ci ASC;
某字段name的字符编码是latin1_swedish_ci;
select*from `tbl` order by birary(name) asc
页:
[1]
查看完整版本:
mysql 按拼音首字母排序的查询语句