Loading lesson path
Concept visual
Start at both ends
Remove leading and trailing spaces from a string:
SELECT TRIM(' SQL Tutorial ') AS TrimmedString;The TRIM() function removes leading and trailing spaces from a string.
string )
Required. The string to remove leading and trailing spaces from
From MySQL 4.0
❮ MySQL Functions