mysql trim spaces in select code example

Example 1: mysql trim whitespace

UPDATE tablename set fieldname = TRIM(fieldname);

Example 2: mysql trim spaces

`field` = TRIM(`field`);