Here is how you can do a quick replace of a particular word in your WordPress blog:

[code lang=“sql”]update wp_posts set post_content = replace(post_content,‘color’, ‘colour’);[/code]

This replaces posts with the word ‘color’ and change it into ‘colour’. I was doing a whole lot of string replacements to replace URLs that are no longer valid.

comments powered by Disqus