trim

description

Syntax

VARCHAR trim(VARCHAR str)

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

example

1. mysql> SELECT trim('   ab d   ') str;
2. +------+
3. | str  |
4. +------+
5. | ab d |
6. +------+

keywords

1. TRIM