CODE EXAMPLE FOR SQL

mysql trim whitespace

UPDATE tablename set fieldname = TRIM(fieldname);