SQL Remove BLANK spaces in varchar field

update formers set
    former_title = replace(former_title, ' ', '');

update formers set
    former_title = replace(former_title, '    ', '');

update formers set
    former_title = replace(former_title, '    ', '');


http://forums.mysql.com/read.php?10,376702,377885#msg-377885