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)
mysql> SELECT rtrim_in('ab d ') str; +------+ | str | +------+ | ab d | +------+ mysql> SELECT rtrim_in('ababccaab','ab') str; +--------+ | str | +--------+ | ababcc | +--------+
RTRIM_IN