REVERSE()

函数说明

将 str 字符串中的字符顺序翻转输出。

函数语法

1. > REVERSE(str)

参数释义

示例

1. > drop table if exists t1;
2. > create table t1(a varchar(12),c char(30));
3. > insert into t1 values('sdfad  ','2022-02-02 22:22:22');
4. > insert into t1 values('  sdfad  ','2022-02-02 22:22:22');
5. > insert into t1 values('adsf  sdfad','2022-02-02 22:22:22');
6. > insert into t1 values('    sdfad','2022-02-02 22:22:22');
7. > select reverse(a),reverse(c) from t1;
8. +-------------+---------------------+
9. | reverse(a)  | reverse(c)          |
10. +-------------+---------------------+
11. |   dafds     | 22:22:22 20-20-2202 |
12. |   dafds     | 22:22:22 20-20-2202 |
13. | dafds  fsda | 22:22:22 20-20-2202 |
14. | dafds       | 22:22:22 20-20-2202 |
15. +-------------+---------------------+
16. > select a from t1 where reverse(a) like 'daf%';
17. +-------------+
18. | a           |
19. +-------------+
20. | adsf  sdfad |
21. |     sdfad   |
22. +-------------+
23. > select reverse(a) reversea,reverse(reverse(a)) normala from t1;
24. +-------------+-------------+
25. | reversea    | normala     |
26. +-------------+-------------+
27. |   dafds     | sdfad       |
28. |   dafds     |   sdfad     |
29. | dafds  fsda | adsf  sdfad |
30. | dafds       |     sdfad   |
31. +-------------+-------------+