If you need to search and replace text in your wordpress blog, such as all comments, there are two ways to do this, the manual way or using a plugin.
BEFORE you do anything, back up your database just to play it safe 
For those of you doing it manually, you’ll need phpmyadmin. If your webhost doesn’t have this free administration tool for mySQL, then you’ll need to download it from http://www.phpmyadmin.net/home_page/index.php
Upload the phpmyadmin directory to your website.
Locate the file config.sample.inc.php and rename it to config.inc.php, then visit yourwebsite/phpmyadmin
Click on the sql tab and enter the following:
UPDATE wp_comments SET comment_content = REPLACE (
comment_content,
‘badword’,
‘goodword’);
Substitute the bad word or term for badword and the good word or term for goodword.
Then click ‘Go’ and you should see the number of rows changed.
That’s it for manual instructions.
To do it the easy way, simply visit wordpress and download the search and replace plugin. Once the plugin is installed, searching and replacing text is a snap!
Comments