Outdated Version
You are viewing an older version of this section. View current production version.
RTRIM
Removes trailing space characters from the given string.
Syntax
RTRIM (str)
Arguments
- str: any string or binary object
Return Type
String
Examples
Info
This function removes only space " " characters. Other whitespace characters like tab \t, newline \n, etc are preserved. It is equivalent to TRIM(TRAILING " " FROM str).
select rtrim(' ohai ') as r, ltrim(' ohai ') as l;
+----------+-----------+
| r | l |
+----------+-----------+
| ohai | ohai |
+----------+-----------+
Related Topics
