mysql trim whitespace

`field` = TRIM(`field`);

UPDATE tablename set fieldname = TRIM(fieldname);