I have a website on Drupal 6 which is being re-branded. The theme is not a problem. However, the website has hundreds of nodes, most of which have references to the original company name.
Is there a way which I can replace every instance of a piece of text with another in a content type. I'm assuming there's not a proper Drupal way of doing this but I wondered if anyone had achieved this somehow. Possibly by querying the database directly to find and replace the text.
Is it just the node table I'd need to query or is there somewhere else which may be hiding bits of text input by the user? Things like taxonomy aren't used on the site, just basic nodes and views as far as I'm aware.
Presumably it'd be something along the lines of:
UPDATE `node` SET `column` = replace(`column`, 'Old Company', 'New Company')