MySQL trim function
MySQL TRIM() function returns a string after removing all prefixes or suffixes from the given string.
Syntax
TRIM([{BOTH | LEADING | TRAILING} [remstr] FROM ] str)
Arguments
Name | Description |
---|---|
BOTH | Indicates that prefixes from both left and right are to be removed. |
LEADING | Indicates that only leading prefixes are to be removed. |
TRAILING | Indicates that only trailing prefixes are to be removed. |
remstr | The string to be removed. |
FROM | Keyword |
str | The actual string from where remstr is to be removed. |
Example
mysql> SELECT TRIM(' trim '); +----------------+ | trim | +----------------+ 1 row in set (0.00 sec)