RTRIM_IN

Description

Syntax

VARCHAR rtrim_in(VARCHAR str[, VARCHAR rhs])

When there is no rhs parameter, remove the spaces that appear consecutively in the parameter str starting from the right part; when there is an rhs parameter, search and remove any characters in the rhs character set at the right end of the string (regardless of order)

Example

mysql> SELECT rtrim_in('ab d   ') str;
+------+
| str  |
+------+
| ab d |
+------+

mysql> SELECT rtrim_in('ababccaab','ab') str;
+--------+
| str    |
+--------+
| ababcc |
+--------+

Keywords

RTRIM_IN