trim

description

Syntax

VARCHAR trim(VARCHAR str)

Remove the space that appears continuously from the starring and ending of the parameter str

example

mysql> SELECT trim('   ab d   ') str;
+------+
| str  |
+------+
| ab d |
+------+

keywords

TRIM