TRIM(): Remove leading and trailing spaces

mysql> SELECT TRIM("          HELLO HOW ARE YOU    ");
+-----------------------------------------+
| TRIM("          HELLO HOW ARE YOU    ") |
+-----------------------------------------+
| HELLO HOW ARE YOU                       |
+-----------------------------------------+
1 row in set (0.00 sec)

Previous                                                 Next                                                 Home