remove whitespace from string in mysql code example Example: mysql trim whitespace UPDATE tablename set fieldname = TRIM(fieldname);