String Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. String Functions
  4. The TRIM() function can trim spaces and characters or groups of characters
mysql>
mysql> SELECT TRIM(TRAILING 'XXX' FROM "FileName.XXX");
+------------------------------------------+
| TRIM(TRAILING 'XXX' FROM "FileName.XXX") |
+------------------------------------------+
| FileName.                                |
+------------------------------------------+
1 row in set (0.00 sec)
mysql>