Skip to main content

TRIM FUNCTIONS

Returns the string str with all remstr prefixes or suffixes removed.

Syntax​

TRIM(expr);
LTRIM(expr);
RTRIM(expr);

Examples​

MySQL [(none)]> SELECT TRIM('   aaa   ');
+-------------------+
| trim('   aaa   ') |
+-------------------+
| aaa               |
+-------------------+

MySQL [(none)]> SELECT LTRIM('   aaa   ');
+--------------------+
| LTRIM('   aaa   ') |
+--------------------+
| aaa                |
+--------------------+

MySQL [(none)]> SELECT RTRIM('   aaa   ');
+--------------------+
| RTRIM('   aaa   ') |
+--------------------+
|    aaa             |
+--------------------+