I client has recently been acquired by a new Group and has requested that I do a search and replace for their name e.g. "Foo Group" and replace this with "New Group". There will be multiple instances of this e.g. "Foo Housing Trust Group" and "Foo Housing Trust".
I can see in a previous post How to fix millions of alt text that are missing on body content that I can use the Search and Replace Scanner module but would this be the best way to do this rather than a DB Query?
Thank you for any help you can provide. Pete.