mysql 按拼音首字母排序的查询语句
时间：2010-09-08 来源：CS_FB4
数据表某字段client_name的字符编码是utf8_general_ci;
Sql代码
- SELECT * FROM `client_info_msg` ORDER BY CONVERT( client_name USING gbk ) COLLATE gbk_chinese_ci ASC;
某字段name的字符编码是latin1_swedish_ci;
Sql代码
- select * from `tbl` order by birary(name) asc
相关阅读 更多 +
