MySQL Function Reference

Returns a string with all spaces removed from the left and right edges

TRIM(str)

SELECT TRIM('  Hello  ')