RTRIM(str): Trim the string str with trailing space characters : RTRIM « String Functions « MySQL Tutorial

1. MySQL Tutorial
2. String Functions
3. RTRIM

mysql>
mysql> SELECT RTRIM('java2s   ');
+--------------------+
| RTRIM('java2s   ') |
+--------------------+
| java2s             |
+--------------------+
1 row in set (0.00 sec)

mysql>