String Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. String Functions
  4. TRIM(LEADING x FROM xxxhava2sxxx)
mysql>
mysql> SELECT TRIM(LEADING 'x' FROM 'xxxhava2sxxx');
+---------------------------------------+
| TRIM(LEADING 'x' FROM 'xxxhava2sxxx') |
+---------------------------------------+
| hava2sxxx                             |
+---------------------------------------+
1 row in set (0.01 sec)
mysql>