What SQL Query to do a simple find and replace?

Posted by Prem Tiwari | Updated on

The table where your URL is saved is wp_options. You should do an update on the columns that use the URL for your site:

I might be missing some value, but whenever you do this find/replace process again, you can notice the values and tables that should be updated and add them to this script.

If you like this question & answer and want to contribute, then write your question & answer and email to freewebmentor[@]gmail.com. Your question and answer will appear on FreeWebMentor.com and help other developers.

Related Questions & Answers