RTRIM() FUNCTION
The MySQL RTRIM function is used to remove all space characters from the right-hand side of a string. The various versions of MySQL supports the RTRIM function, namely, MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0 and MySQL 3.23.
Syntax:
RTRIM( string )
Parameters:
string: It is used to specify the string to modify.
Example 1:
mysql> SELECT RTRIM ( 'HELLO ' ); |
Output:
'HELLO’ |
Explanation:
All thee space characters are removed from the right-hand side of the string.
Example 2:
mysql> SELECT RTRIM ( ' HELLO ' ); |
Output:
' HELLO’ |
Explanation:
All thee space characters are removed from the right-hand side of the string.
Please Share