Syntax
TRIM([[{BOTH | LEADING | TRAILING}] [remstr] FROM] str
Purpose
TRIM() deletes all prefixes and/or suffixes of a string. The default value is BOTH. If the parameters include a NULL value, the function returns NULL.
Examples
obclient> 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