MariaDB: LTRIM Function

This MariaDB tutorial explains how to use the MariaDB LTRIM function with syntax and examples.

Description

The MariaDB LTRIM function removes all space characters from the left-hand side of a string.

Syntax

The syntax for the LTRIM function in MariaDB is:

LTRIM( string )

Parameters or Arguments

string

The string to trim the space characters from the left-hand side.

Applies To

The LTRIM function can be used in the following versions of MariaDB:

• MariaDB 10

Example

Let's look at some MariaDB LTRIM function examples and explore how to use the LTRIM function in MariaDB.

For example:

SELECT LTRIM('   AODBA.com');
Output: 'AODBA.com'



SELECT LTRIM('    AODBA.com knows MariaDB!');
Output: 'AODBA.com knows MariaDB!'