SQL•SQL References

MySQL RTRIM() Function

Example

SELECT RTRIM("SQL Tutorial     ") AS RightTrimmedString;

Definition and Usage

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

Syntax

RTRIM(
string
)

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

Works in:	From MySQL 4.0

Loading lesson path

SQL•SQL References

Example

SELECT RTRIM("SQL Tutorial     ") AS RightTrimmedString;

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

Syntax

RTRIM(
string
)

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

Works in:	From MySQL 4.0