Mega Code Archive

 

Categories / MySQL Tutorial / String Functions

 

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>