MySQL RTRIM() Function

Remove trailing spaces from a string:

SELECT RTRIM("SQL Tutorial ") AS RightTrimmedString;

Definition and Usage

The RTRIM() function removes trailing spaces from a string.

RTRIM( string)

Parameter	Description
string	Required. The string to remove trailing spaces from

Works in:	From MySQL 4.0