Keep forgetting this. Replace a string in all rows:
UPDATE <table> SET <column> = REPLACE(<column>, '<string to find>', '<string to replace>');
MySQL string replace
23rd Mar 2010