I really should have figured out how to do this sooner
update node_revisions set body = replace (body, 'photo=old_id', 'photo=new_id');
No more select, fetch, regex, update just to change a little bit of content.
update node_revisions set body = replace (body, 'photo=old_id', 'photo=new_id');
No more select, fetch, regex, update just to change a little bit of content.
Post new comment