mysql 中文字段排序( UTF8按拼音首字母排序)

select * from tableName CONVERT( FieldName USING gbk ) COLLATE gbk_chinese_ci desc