Mega Code Archive

 

Categories / MySQL Tutorial / String Functions

 

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>