SinceVersion 1.2

convert_to

description

Syntax

VARCHAR convert_to(VARCHAR column, VARCHAR character) 在order by子句中使用，例如order by convert(column using gbk), 现在仅支持character转为’gbk’. 因为当order by column中包含中文时，其排列不是按照汉语拼音的顺序. 将column的字符编码转为gbk后，可实现按拼音的排列的效果.

example

1. mysql> select * from class_test order by class_name;
2. +----------+------------+-------------+
3. | class_id | class_name | student_ids |
4. +----------+------------+-------------+
5. |        6 | asd        | [6]         |
6. |        7 | qwe        | [7]         |
7. |        8 | z          | [8]         |
8. |        2 | 哈         | [2]         |
9. |        3 | 哦         | [3]         |
10. |        1 | 啊         | [1]         |
11. |        4 | 张         | [4]         |
12. |        5 | 我         | [5]         |
13. +----------+------------+-------------+

15. mysql> select * from class_test order by convert(class_name using gbk);
16. +----------+------------+-------------+
17. | class_id | class_name | student_ids |
18. +----------+------------+-------------+
19. |        6 | asd        | [6]         |
20. |        7 | qwe        | [7]         |
21. |        8 | z          | [8]         |
22. |        1 | 啊         | [1]         |
23. |        2 | 哈         | [2]         |
24. |        3 | 哦         | [3]         |
25. |        5 | 我         | [5]         |
26. |        4 | 张         | [4]         |
27. +----------+------------+-------------+

keywords

1. convert_to