SQL•SQL References

MySQL TRIM() Function

Example

SELECT TRIM('    SQL Tutorial    ') AS TrimmedString;

Definition and Usage

The TRIM() function removes leading and trailing spaces from a string.

Syntax

TRIM(
string
)

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

Works in:	From MySQL 4.0

Loading lesson path

SQL•SQL References

Example

SELECT TRIM('    SQL Tutorial    ') AS TrimmedString;

The TRIM() function removes leading and trailing spaces from a string.

Syntax

TRIM(
string
)

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

Works in:	From MySQL 4.0