MySQL8 LTRIM() Functions – String Functions

by · Published · Updated

MySQL LTRIM() Functions: Syntax

LTRIM ( string );

MySQL LTRIM() Functions: Description

LTRIM() functions remove all leading spaces from the input string.

Note : This function is multibyte safe.

MySQL LTRIM() Functions: Parameter

[table caption=”” width=”100%” colwidth=”15%|30%|55%” colalign=”left|left|left”]
Name, Required /Optional, Description
string, Required, Input string is must.
[/table]

MySQL LTRIM() Functions: Output

[table caption=”” width=”100%” colwidth=”20%|80%” colalign=”left|left”]
Returns, String after leading space characters are removed.
[/table]

MySQL LTRIM() Functions: Available from

[table caption=”” width=”100%” colwidth=”25%|75%” colalign=”left|left”]
Version, MySQL 4.0
[/table]

MySQL LTRIM() Functions: Example 1

mysql> SELECT LTRIM('   Tuts');
+------------------------------------+
| LTRIM('   Tuts') |
+------------------------------------+
| Tuts                       |
+------------------------------------+
1 row in set (0.00 sec)

See all MySQL String functions MySQL 8 String Functions.

Related articles : UCASE(), UPPER(), LCASE(), LOWER(), TRIM(), RTRIM().

PHP Related articles : TRIM(), LTRIM(), RTRIM(), PHP STRING FUNCTIONS().

You may also like...