When it comes to managing your WordPress website, making minor changes here and there isn’t usually a big deal. However, sometimes you need to update many elements on your site at once, in which case a WordPress search and replace may be necessary.

Perhaps you just migrated from HTTP to HTTPS, for example, and you need to update all of your hard-coded HTTP URLs in the WordPress database. Alternatively, maybe you are changing domains and need to update all the database references. There are many scenarios in which knowing how to perform a bulk WordPress search and replace can save you a lot of time.

In this post, we’ll explain what a WordPress search and replace is and when conducting one might be necessary. Then we’ll walk you through five different ways you can do this.

Let’s get started!

Whether you just migrated from HTTP to HTTPS, are changing domains, or just need to make a bulk change to your site, search and replace makes things easy. ✅ Click to learn more ⬇️Click to Tweet

An Overview of WordPress Search and Replace

There are a handful of situations in which you may need to perform a search and replace on your WordPress site. One of the most common scenarios is when you want to replace a piece of text (such as a disclaimer or bio) that you added to multiple pages or posts, but you don’t know every place it’s currently located.

Being able to conduct a mass search and replace saves a lot of time, in contrast to manually searching every post and page for the text you want to switch out. Plus, you can use this technique on more than just text.

For instance, you can also perform a mass WordPress search and replace for URLs and images in your WordPress database. This functionality comes in handy if you want to:

One thing we want to mention is that there’s no ‘undo’ option. Once you replace the text or other content, you can’t get the old version back. You would have to do another mass search and replace in order to reverse the process. That’s why we strongly suggest performing a backup before any WordPress search and replace routine.

How to Perform a WordPress Search and Replace (5 Methods)

There are a lot of different ways to perform a WordPress search and replace. Let’s take a look at five recommended options.

1. Use MyKinsta’s Search and Replace Tool

If you are a Kinsta customer, you can use our own search and replace tool. It’s available right within the MyKinsta dashboard. To locate this tool, navigate to Sites, and then click on the name of the website you want to run the search and replace on:

mykinsta sites

The MyKinsta dashboard.

Next, select Tools and navigate to the Search and Replace option:

search replace mykinsta

The Kinsta Search and Replace tool.

As we mentioned earlier, there are a number of different operations you can use this tool for. In this example, we’ll be changing some URLs that use “http” to ones using “https”.

In the search field, enter the value you want to look for in the database, and hit Search. The search and replace tool will display the number of occurrences for the given string:

mykinsta search box

A search using the MyKinsta search and replace tool.

Check the Replace box to continue with the process. In the Replace with field, enter the new text, URL, or other value:

mykinsta replace field

The Replace field in the MyKinsta search and replace tool.

We recommend leaving the Clear cache when ready box checked, to automatically purge your site’s cache after the search and replace process. That way, visitors will see the updated version of your website right away. Then, click on the Replace button.

After the WordPress search and replace is complete, you’ll see a confirmation dialog showing the number of replacements that were processed. When you’re done, select Cancel to exit the search and replace tool. That’s it!

2. Install a WordPress Search and Replace Plugin

If you’re not hosting at Kinsta, or you want another option to perform a WordPress search and replace without manually searching your database, you can also use a plugin. One popular solution you can use for this is Better Search Replace:

better search replace

The Better Search Replace WordPress plugin.

The Better Search Replace plugin is developed by the WordPress team over at Delicious Brains, and is inspired by the interconnect/it PHP script, which we’ll mention in the next method.

Info

At the time of this writing, Better Search Replace hasn’t been updated in several months. Although we haven’t experienced any issues when trying it, we strongly suggest to make a backup of your site and test it on a staging environment before pushing it on a live site.

Some of Better Search Replace’s features include:

There are hundreds of different use cases for this tool. As you can see you in our example below, in the Better Search Replace options you could easily search for any hard-coded HTTP references and update with the HTTPS versions:

search replace options

The Better Search Replace plugin options.

There is also a pro version of the plugin available, which gives you access to even more features. You can check out the official documentation on how to better use this plugin.

Another tool you might consider using is Search Regex:

Search Regex WordPress plugin

The Search Regex WordPress plugin.

While it’s sufficient for performing basic search and replace tasks, including updating URLs and content in bulk, this plugin is not as popular or widely used as Better Search Replace. Still, it’s an actively-maintained and well-rated tool that can get the job done, and it’s simple to use.

You can download either solution from the WordPress repository. Alternatively, you can search for them within your WordPress dashboard under Plugins > Add New.

3. Use the interconnect/it Search Replace DB PHP Script

You may not want to install another plugin on your WordPress site. If so, another way you can perform a WordPress search and replace is to use a free PHP script from interconnect/it called Search Replace DB:

interconnect it website

The interconnect/it website.

It’s important to note that using this script could break your WordPress website if you don’t know what you’re doing. If you are not comfortable with this method, please check with a developer or your web host first.

This script has been around since 2011, and the developers actively update it. To use the script, simply download the zip file, extract the folder called “search-replace-db-master”, and rename it to something of your choosing.

In our example, we renamed it to “update-db-1551”:

interconnect search replace script

Uploading the Interconnect search and replace script.

Next, upload the file via FTP or SFTP, to your web server’s public directory. This is typically the same directory that contains your /wp-content folder. Then navigate to your secret folder in your browser, such as “https://domain.com/update-db-1551”.

The script will automatically attempt to find and populate the database field. However, you must check to ensure that the details are correct and that they are the right ones for the database you wish to carry out a search and replace operation on.

You can click on dry run first to see what the script will be updating or replacing. When you’re ready, select live run, which will perform the database updates and the WordPress search and replace:

interconnect search replace

Running a search and replace on a WordPress database.

Also, for security reasons, it’s very important that you delete this script after you are done! You can select the delete me button to do this.

If you don’t, it could leave your website open to attacks. It is also best to double-check your web server to confirm that the folder and script have been completely removed.

Need a hosting solution that gives you a competitive edge? Kinsta’s got you covered with incredible speed, state-of-the-art security, and auto-scaling. Check out our plans

4. Perform the Search and Replace Directly With WP-CLI

Another method you can use to perform a WordPress search and replace is to do it directly with WP-CLI. This is an option for the WordPress developers out there.

To Kinsta customers, we provide SSH access so you can use WP-CLI. If you are unfamiliar with WP-CLI, you can check out our in-depth post on managing WordPress from the terminal and a curated list of useful SSH commands.

Here is an example of what the command looks like:

wp search-replace 'http://example.dev' 'http://example.com' --precise --recurse-objects --all-tables

You can read more about the parameters available to you for the wp search-replace command in the official WP-CLI documentation. You may also want to check out this advanced search and replace WP-CLI guide.

5. Run a Find and Replace MySQL Query With phpMyAdmin

If you are comfortable working with code and would prefer not to use a plugin to perform a search and replace in your WordPress database, you can also use MySQL query in phpMyAdmin. However, this should only be done by professional WordPress developers.

If your hosting provider uses cPanel, then you can browse to and select phpMyAdmin under Databases:

databases phpmyadmin

PhpMyAdmin from the cPanel ‘databases’ section.

Kinsta customers can access phpMyAdmin directly from the MyKinsta dashboard. To do this, click on your site first. Then under the Info tab, scroll down to the Database access section and click on Open phpMyAdmin:

phpmyadmin mykinsta

The phpMyAdmin link in the MyKinsta dashboard.

A new tab will open with the phpMyAdmin login page. Enter your database username and password, then select Go:

kinsta phpMyAdmin login

The Kinsta phpMyAdmin login page.

Once you’ve accessed phpMyAdmin, locate your database’s name. If you need help doing this, navigate to your File Manager. Under the public_html folder, open your wp-config.php file, and look for the line that reads “define(‘DB_NAME’, ‘Database Name‘);”.

Next, from phpMyAdmin, select the SQL tab:

phpmyadmin sql

The ‘SQL’ tab in phpMyAdmin.

Add the following code snippet:

update TABLE_NAME set FIELD_NAME = replace(FIELD_NAME, 'Text to search, 'Text to replace it with');

Then click on the Go button to run your SQL query. When the process is done, it will display a success message indicating the number of changed instances. You can visit your WordPress site to confirm that the search and replace was successful.

Don't let minor tweaks to your #WordPress site take up your day. ⏳ Use search and replace to quickly and easily implement changes and get started with your new and improved site. ✨Click to Tweet

 

Summary

Whether you’re looking to update your keywords or replace a specific piece of text on all your posts, learning how to perform a mass search and replace is incredibly helpful. Fortunately, there are multiple methods you can use to do this.

Five techniques we recommend using for a WordPress search and replace include:

  1. Use our own search and replace tool in your MyKinsta dashboard.
  2. Install a WordPress search and replace plugin, such as Better Search Replace or Search & Replace.
  3. Use the interconnect/it Search Replace DB PHP script.
  4. Perform the search and replace directly using WP-CLI.
  5. Run a MySQL query with phpMyAdmin.

If you enjoyed this tutorial, then you’ll love our support. All Kinsta’s hosting plans include 24/7 support from our veteran WordPress developers and engineers. Chat with the same team that backs our Fortune 500 clients. Check out our plans