THE WORLD'S LARGEST WEB DEVELOPER SITE

MySQL TRIM() Function

❮ MySQL Functions

Example

Remove leading and trailing spaces from a string:

SELECT TRIM('    SQL Tutorial    ') AS TrimmedString;
Try it Yourself »

Definition and Usage

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

Syntax

TRIM(string)

Parameter Values

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

Technical Details

Works in: From MySQL 4.0

❮ MySQL Functions