MariaDB: RTRIM Function
This MariaDB tutorial explains how to use the MariaDB RTRIM function with syntax and examples.
Description
The MariaDB RTRIM function removes all space characters from the right-hand side of a string.
Syntax
The syntax for the RTRIM function in MariaDB is:
RTRIM( string )
Parameters or Arguments
- string
- The string to trim the space characters from the right-hand side.
Applies To
The RTRIM function can be used in the following versions of MariaDB:
- MariaDB 10
Example
Let's look at some MariaDB RTRIM function examples and explore how to use the RTRIM function in MariaDB.
For example:
SELECT RTRIM('TechOnTheNet.com '); Result: 'TechOnTheNet.com' SELECT RTRIM(' Tech on the net '); Result: ' Tech on the net' SELECT RTRIM('TechOnTheNet.com knows MariaDB! '); Result: 'TechOnTheNet.com knows MariaDB!'
Advertisements