MYSQL - Remove character/blank space in table fields.

UPDATE table_name
SET field_name= REPLACE(field_name,'<character to find>', '<character to replace>');