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