ltrim

Description

Removes the leading spaces from the beginning (left) of the str argument.

Syntax

VARCHAR ltrim(VARCHAR str)

Parameters

str: required, the string to trim, which must evaluate to a VARCHAR value.

Return value

Returns a VARCHAR value.

Examples

Remove spaces from the beginning of the string.

MySQL > SELECT ltrim('   ab d');
+------------------+
| ltrim('   ab d') |
+------------------+
| ab d             |
+------------------+

References

• trim
• rtrim

keyword

LTRIM