Mega Code Archive

 

Categories / MySQL Tutorial / String Functions

 

TRIM(TRAILING xyz FROM java2sxxyz)

mysql> mysql> SELECT TRIM(TRAILING 'xyz' FROM 'rntsoftxxyz'); +----------------------------------------+ | TRIM(TRAILING 'xyz' FROM 'rntsoftxxyz') | +----------------------------------------+ | rntsoftx                                | +----------------------------------------+ 1 row in set (0.01 sec) mysql>