trim

Description

Syntax:

VARCHAR trim(VARCHAR str)

This function removes the continuous whitespace in the string.

Example

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

Keywords

TRIM