How To Replace WordPress Post Content Text Strings

Here’s a tip on how you can replace a specific keyword/text string in all your WordPress posts and pages. It’s actually quite simple and involves only 1 line of SQL code.

For example, let’s say you want to replace all the text “my homepage” to “my blog”:

update wp_posts set post_content = replace(post_content, "my homepage", "my blog")

That’s it!