TRIM
trim
description
Syntax
VARCHAR trim(VARCHAR str[, VARCHAR rhs])
When the 'rhs' parameter is not present, remove the continuous spaces that appear from the starting and ending of the 'str' parameter. Otherwise, remove 'rhs'.
example
mysql> SELECT trim(' ab d ') str;
+------+
| str |
+------+
| ab d |
+------+
mysql> SELECT trim('ababccaab','ab') str;
+------+
| str |
+------+
| cca |
+------+
keywords
TRIM