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

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

Syntax

MYSQL Copy

SELECT TRIM('  bar   ');
'bar'
SELECT TRIM(LEADING 'x' FROM 'xxxbarxxx');
'barxxx'
SELECT TRIM(BOTH 'x' FROM 'xxxbarxxx');
'bar'
SELECT TRIM(TRAILING 'xyz' FROM 'barxxyz');
'barx'

Examples

Example

Returns the string str with all remstr prefixes or suffixes removed. If none of the specifiers BOTH, LEADING, or TRAILING is given, BOTH is assumed. remstr is optional and, if not specified, spaces are removed.

MYSQL Copy

SELECT TRIM('  bar   ');
'bar'
SELECT TRIM(LEADING 'x' FROM 'xxxbarxxx');
'barxxx'
SELECT TRIM(BOTH 'x' FROM 'xxxbarxxx');
'bar'
SELECT TRIM(TRAILING 'xyz' FROM 'barxxyz');
'barx'