Find and replace in WordPress Database
If you need to mass find and replace something in WordPress database it can be a very time consuming job going through one table and the other. You can use the following tool to find and replace any content in the wordpress database including any content on the posts and pages.
WordPress Find and Replace tool: https://interconnectit.com/products/search-and-replace-for-wordpress-databases/
This is a simple php file that will pick up your database details from your wp-config.php file and then populate to connect with your database. Once connected you will be given database tables that you want to search from. You can choose all or any multiple tables. Next you are given the option to search term that can be anything and you can also type in the replace text as well.
Beware: Once you click find and replace that is it. The changes will be implemented in a flash there is no popup and your changes will be done. If you make a mistake I hope you have taken a backup of the database and can bring that back or you can use the same facility to find and replace things as they were.