MYSQL - Remove character/blank space in table fields.

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

MYSQL - Join Table

SELECT a.field1,a.field2,b.field3,b.field4
FROM table1 a, table2 b
where a.field1 = b.field3