Every so often you get into the situation where you are running a wordpress blog that has thousands of posts that need a small portion edited. Unfortunately, wordpress does not come readily available with a “find & replace” type function. There are some “find & replace” plugins but they didn’t seem to edit the HTML within the posts the way I wanted. Since it took me a little time to figure out how this is done, I figured I’d share it with you.
1) Open PHPmyAdmin
2) Click on the name of your wordpress database
3) Click on the “SQL” tab
4) Type the following code
5) Hit ‘Go’
That’s it. You can literally “Find & Replace” anything within all of your posts within seconds. Hope this helps someone.