mysql> select rtrim(" cdcdcd ");+--------------------+| rtrim(" cdcdcd ") |+--------------------+| cdcdcd |+--------------------+1 row in set (0.00 sec)