How to Search & Replace WordPress Database

When I moved SourceWP to https this search and replace option was really handy and made things a lot easier for me. When you install SSL certificate on your site, you will have to fix a few things, remove certain URLs, replace some to make it work properly.

The same thing happened with me, I had to fix some URLs so that it doesn't show a broken SSL link in the browser. As the site was on http for a long time some of the links are hard coded and really difficult to get rid of.

Most of the times, the image links are served over http instead of https which need to be replaced. It is not easy for every wordPress user to dig into the database and fix the issues, you have to be technically sound and understand the database to get that done.

The good news is that there are tools and plugins that will help you to get that done very easily without the requirement of any technical knowledge. In this post, we will discuss search & replace WordPress plugins that will help you to search & replace domains and URLs from your database

Also Read:

Best Search & Replace WordPress Database Plugins

Nate: Before you do any search & replace make sure that you have a backup of your site database to be on a safer side.

Search & Replace

This is a very simple and straight forward plugin which is extremely easy for anyone to get things done. You don't have to be an expert to use this plugin, just install the plugin like any other WordPress plugin and get started.

Once you activate the plugin, you can get started with the required replacements. This plugin can handle a lot of things, you can search and replace URLs, change table prefix, backup & restore your database to make sure everything is as per your requirement.

You can make a dry run or download the SQL file and save after making the changes.  It's really simple and easy to search anything and replace with your desired content.

search-replace

There are different tables that you can select depending on your requirement. If you want to make any changes in the posts, you can select the post table and accordingly you can make the changes. This plugin will definitely save a lot of time for you and make it super easy.

More Info & Download Plugin

Better Search Replace

Another similar kind of plugin that help you to streamline things after you change the domain, migrate to new server or move to SSL link. You can run simple search & replace query to make things work as per your requirement.

You can achieve the following with this plugin

  • Serialization supports for all tables
  • The ability to select specific tables
  • The ability to run a “dry run” to see how many fields will be updated
  • No server requirements aside from a running installation of WordPress
  • WordPress Multisite support

The dry-run option will highlight the number of possible replacements without actually replacing them so that you can make sure before you make the final changes. This plugin is extremely handy and easier to manage.

better-search-replace

You have the option to select the tables where you want to make the changes.

More Info & Download Plugin

Final Word

There are a couple of other plugins which can do this task for you. However, these two plugins are the most widely used and come with a proven track record. So, if you are planning to move your site to SSL, you can take help of these two plugins to make sure that everything is streamlined and working properly.

How to Search & Replace WordPress Database
5 (100%) 1 vote