How to Find and Replace Text with One Click in your WordPress Database345

Author: InfoBeep - October 19, 2017 | subject to copyright

When you may need find and replace for WordPress database?

Sometimes, you may want to change certain words in your WordPress database. If it is only at one place then it may not be a big issue, but if there is a lot of it? It is difficult for you to go and find every word and change it accordingly.

We have got the solution for you in this article, we will guide you to find and replace text with one click.

Running find and replace with a WordPress plugin

In this method, you need to Install and activate ‘Better Search Replace’ plugin. This plugin allows you to search and replace word inside WordPress admin area. You can see the demo picture below:

searchreplace

Running find & replace MySQL query with phpMyAdmin

To find & replace word using phpMyAdmin follow the steps below:

  • Login in to cPanel dashboard and then click on phpMyAdmin from the database section. Demo picture (your cPanel might look slightly different) shown below:

phpmyadmin

  • After phpMyAdmin starts click on SQL. Demo picture shown below:

sql

  • Enter SQL query in the format shown below:
update TABLE_NAME set FIELD_NAME =

replace(FIELD_NAME, 'Text to find', 'text to replace with');
  • Click on go button to continue. After done it shows the number of rows affected.