LTRIM()

Function Description

LTRIM() removes the front space of the input string and returns the processed characters.

Function Syntax

> LTRIM(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 ltrim(a),ltrim(b) from t1;

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