remove whitespace from string mysql code example

Example: mysql trim whitespace

UPDATE tablename set fieldname = TRIM(fieldname);