MySQL8 RTRIM() Functions – String Functions

by · Published · Updated

MySQL RTRIM() Functions: Syntax

RTRIM ( string );

MySQL RTRIM() Functions: Description

RTRIM() functions removes all trailing spaces from the input string.

Note : This function is multibyte safe.

MySQL RTRIM() Functions: Parameter

[table caption=”” width=”100%” colwidth=”15%|30%|55%” colalign=”left|left|left”]
Name, Required /Optional, Description
string, Required, Input string is must.
[/table]

MySQL RTRIM() Functions: Output

[table caption=”” width=”100%” colwidth=”20%|80%” colalign=”left|left”]
Returns, String after trailing space characters are removed.
[/table]

MySQL LOWER() Functions: Available from

[table caption=”” width=”100%” colwidth=”25%|75%” colalign=”left|left”]
Version, MySQL 4.0
[/table]

Related articles : UCASE(), UPPER(), LCASE(), LOWER(), TRIM(), LTRIM().

PHP Related articles : TRIM(), LTRIM(), RTRIM(), PHP STRING FUNCTIONS().

MySQL RTRIM() Functions: Example 1

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

See all MySQL String functions MySQL 8 String Functions.

You may also like...