TRIM

Declaration

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

Description

Removes all leading and/or trailing characters from a string. The default is BOTH. If any parameter is NULL, the result is NULL.

Examples

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)