RTRIM(str)

Returns the string str with trailing space characters removed.

Syntax

MYSQL Copy

SELECT RTRIM('barbar   ');
'barbar'

Examples

Example

This function is multibyte safe, and returns NULL if str is NULL.

MYSQL Copy

SELECT RTRIM('barbar   ');
'barbar'