SQL•SQL References

MySQL LTRIM() Function

Example

SELECT LTRIM("     SQL Tutorial") AS LeftTrimmedString;

Definition and Usage

The LTRIM() function removes leading spaces from a string.

Syntax

LTRIM(
string
)

Parameter	Description
string	Required. The string to remove leading spaces from

Works in:	From MySQL 4.0

Loading lesson path

SQL•SQL References

Example

SELECT LTRIM("     SQL Tutorial") AS LeftTrimmedString;

The LTRIM() function removes leading spaces from a string.

Syntax

LTRIM(
string
)

Parameter	Description
string	Required. The string to remove leading spaces from

Works in:	From MySQL 4.0