REVERSE()

函数说明

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

函数语法

  1. > REVERSE(str)

参数释义

参数说明
Str必要参数. 需要翻转的字符串. CHAR与VARCHAR类型均可.

示例

  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. +-------------+-------------+

限制

MatrixOne目前只支持在查询表的时候使用函数，不支持单独使用函数。