mysql trim whitespace
snippet in sql

mysql trim spaces

user775

`field` = TRIM(`field`);

mysql trim whitespace

user4839

UPDATE tablename set fieldname = TRIM(fieldname);