Removing leading and trailing spaces with Trim – MySQL

UPDATE table set column_name = TRIM(column_name);

To remove non-whitespace characters
UPDATE FOO set FIELD2 = TRIM(Replace(Replace(Replace(FIELD2,'\t',''),'\n',''),'\r',''));
https://stackoverflow.com/questions/6858143/how-to-remove-leading-and-trailing-whitespace-in-a-mysql-field/6858168