RTRIM()

Function Description

RTRIM() removes the space behind the input string and returns the processed characters.

Function Syntax

> RTRIM(char)

Parameter definition

Parameters	Description
char	Required parameters, both CHAR and VARCHAR are available

Example

> drop table if exists t1;
> create table t1(a char(8),b varchar(10));
> insert into t1 values('matrix ','matrixone ');
> select rtrim(a),rtrim(b) from t1;

+--------------------------+
| rtrim(a) | rtrim(b) |
+--------------------------+
| matrix | matrixone |
+--------------------------+