MySQL TRIM 函数

• 

  定义和用法

  TRIM - 返回字串。
• 

  语法

  TRIM([{BOTH | LEADING | TRAILING} [remstr] FROM] str)，TRIM([remstr FROM] str)

  复制

  返回删除了所有remstr前缀或后缀的字符串str。 如果没有给出两个说明符BOTH，LEADING或TRAILING，则假定两者均为。 remstr是可选的，如果未指定，则删除空格。
• 

  示例

  mysql> SELECT TRIM('  bar   ');
  +---------------------------------------------------------+
  |                     TRIM('  bar   ')                    |
  +---------------------------------------------------------+
  |                          bar                            |
  +---------------------------------------------------------+
  1 row in set (0.00 sec)
  
  mysql> SELECT TRIM(LEADING 'x' FROM 'xxxbarxxx');
  +---------------------------------------------------------+
  |            TRIM(LEADING 'x' FROM 'xxxbarxxx')           |
  +---------------------------------------------------------+
  |                         barxxx                          |
  +---------------------------------------------------------+
  1 row in set (0.00 sec)
  
  mysql> SELECT TRIM(BOTH 'x' FROM 'xxxbarxxx');
  +---------------------------------------------------------+
  |            TRIM(BOTH 'x' FROM 'xxxbarxxx')              |
  +---------------------------------------------------------+
  |                          bar                            |
  +---------------------------------------------------------+
  1 row in set (0.00 sec)
  
  mysql> SELECT TRIM(TRAILING 'xyz' FROM 'barxxyz');
  +---------------------------------------------------------+
  |           TRIM(TRAILING 'xyz' FROM 'barxxyz')           |
  +---------------------------------------------------------+
  |                         barx                            |
  +---------------------------------------------------------+
  1 row in set (0.00 sec)
  

  复制

  尝试一下