TRIM

声明

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

说明

删除字符串所有前缀和/或后缀，默认为 BOTH。参数中包含 NULL 时，返回 NULL。

示例

SELECT
   TRIM(' bar '),
   TRIM(LEADING 'x' FROM 'xxxbarxxx'),
   TRIM(BOTH 'x' FROM 'xxxbarxxx'),
   TRIM(TRAILING 'x' FROM 'xxxbarxxx')
   \G
*************************** 1. row ***************************
                      TRIM(' bar '): bar
 TRIM(LEADING 'x' FROM 'xxxbarxxx'): barxxx
    TRIM(BOTH 'x' FROM 'xxxbarxxx'): bar
TRIM(TRAILING 'x' FROM 'xxxbarxxx'): xxxbar
1 row in set (0.001 sec)