String Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. String Functions
  4. TRIM(BOTH x FROM xxxjava2sxxx)
mysql>
mysql> SELECT TRIM(BOTH 'x' FROM 'xxxrntsoftxxx');
+------------------------------------+
| TRIM(BOTH 'x' FROM 'xxxrntsoftxxx') |
+------------------------------------+
| rntsoft                             |
+------------------------------------+
1 row in set (0.00 sec)
mysql>