Mysql TRIM
From w3cyberlearnings
Contents |
MySQL TRIM Function
This function removes prefixed or suffixed whitespace between string.
Syntax TRIM
- Str: a given string that may contain whitespace.
TRIM(Str);
Example 1
mysql> SELECT TRIM(' boy girl ');
+----------------------+
| TRIM(' boy girl ') |
+----------------------+
| boy girl |
+----------------------+
1 row in set (0.00 sec)
