String Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. String Functions
  4. SELECT TRIM(LEADING XXX FROM XXXFileName)
mysql>
mysql> SELECT TRIM(LEADING 'XXX' FROM "XXXFileName");
+----------------------------------------+
| TRIM(LEADING 'XXX' FROM "XXXFileName") |
+----------------------------------------+
| FileName                               |
+----------------------------------------+
1 row in set (0.00 sec)