mysql trim spaces
snippet in sql

mysql trim spaces

user2623

`field` = TRIM(`field`);

mysql trim whitespace

user7515

UPDATE tablename set fieldname = TRIM(fieldname);