WordPress.org

Ready to get started?Download WordPress

Plugin Reviews

Search and Replace

A simple search for find strings in your database and replace the string.

14567

63 reviews
Average Rating
4 stars
4.4 out of 5 stars
5 stars
Very useful plugin!
By , for WP 3.5.1

This plugin was extremely helpful when I was moving from the test-subsite to the live site. Solved the problem replacing URL in the database. Will donate.
Thank you!

5 stars
Legit
By ,

Very handy

2 stars
Powerful, confusing, dangerous
By , for WP 3.5.1

This plugin advises you to back up your database before using it, which is good, because it is really easy to shoot yourself in the foot with this plugin.

The user experience is confusing. It tries to get you to experiment before doing anything that will actually change data, which is great, but in doing so, it adds complexity and confusion.

I have a few ideas on making it clearer and safer.

  • For consistency, give people the option to limit the tables & fields they search agains in the trial/test section (it is currently only available when changing the database
  • Make the whole process more "wizzard-like." Hide the UI for the potentially destructive actions and only expose it once the user has made the trial actions
  • Require people to test the search/replace before allowing them to perform any changes on data.
  • Once people have done a trial run, don't let them change the search/replace data before performing changes on data unless they do a new trial run
  • Before performing changes, automatically make backup copies of the tables that will be changed

So, the flow would be:

  1. Click to the Search & Replace Screen
  2. Select fields and tables, enter search and replace criteria
  3. Click to run a trial query
  4. Review results
  5. Click to proceed with changing the database, or return to step #2 and alter the selected fields and criteria
  6. Confirm that you want to backup the tables and change the database
  7. Database table(s) is copied to a backup table(s), replace query is run
  8. User reviews results, is given the option of reverting to the backup tables
  9. If user clicks to approve of the results, they are then asked if they want to delete the backup.
  10. If they do not choose to delete the backup, the backup tables will be listed on a section of the main Search & Replace page where they can choose to delete them. If they don't choose to restore the backup immediately after running and reviewing the replace action, they are not given the option on the list of old backups. In order to reduce the chance that they accidentally restoring over new data, they will have to work directly with the database.
3 stars
Powerful but Dangerous
By , for WP 3.5.1

This is an incredibly powerful plugin that easily allows you to make changes to your entire database. However, I have found that it causes the Redirect plugin to break leading to a huge manual effort to sort through my 301 redirects.

5 stars
Exactly what I needed
By , for WP 3.5.1

A process that would have taken all day was fixed in less than 30 seconds. Thanks for the plugin!

5 stars
Love it! Very Useful
By , for WP 3.5.1

This plugin can be a life saver if you ever move your site or make major updates. Came in very handy when I moved a site from one hosting account to another.

Another time it came in very handy is when I installed the Better WP Security plugin. A few of my sites were hacked so I wanted a plugin that would help make my site more secure. Better WP Security makes some major changes to your WP install if you let it. One is to change the wp-content folder name to prevent hacking bots. After doing that, though, many of my image references wouldn't work. Big problem? Not with Search and Replace. Just ran it to replace the old path with the new and I was golden. This is a great plugin!!!

5 stars
Worked Perfectly
By , for WP 3.5.1

This worked perfectly and was quick and easy to use.

5 stars
Really cool !
By , for WP 3.4.2

Fantastic! It saves my huge time. Thanks author.

5 stars
Excellent!
By , for WP 3.4.2

Thanx for plugin! Saved a lot of times for me.

5 stars
saving grace after moving servers
By , for WP 3.4.2

I moved between servers and this plugin really helped me determine why my image links were broken. Turns out that it was some entries in the database that were still pointing to the old server.

You must log in to submit a review. You can also log in or register using the form near the top of this page.