Pretty simple find and replace:
update [table_name] set [field_name] = replace([field_name],’[string_to_find]‘,’[string_to_replace]‘);
OMG, I am glad I listened in the database classes all those years ago :) I’m upgrading an older WordPress blog to the latest version and that lil query saved my life!