SQL for field text replacements

Search and Replace Strings
Tables and Fields
Generated SQL 
UPDATE tablename SET fieldname = REPLACE(fieldname, 'searchfor', 'replacewith') WHERE INSTR(fieldname, 'searchfor') > 0;