remove left and right spaces from mysql string code example
Example 1: mysql trim whitespace
UPDATE tablename set fieldname = TRIM(fieldname);
Example 2: mysql trim spaces
`field` = TRIM(`field`);
UPDATE tablename set fieldname = TRIM(fieldname);
`field` = TRIM(`field`);