Replace all Occurrences of URL Globally in WordPress


When user redirect link to new address which is widely used inside multiple posts then changing each link is almost difficult in every post. Following tutorial will explain you how to replace every occurrence of URL using simple phpmyadmin query.

Problem Statement :

I need to change every occurrence of www.xyz.com with www.abc.com.

Solution : Change URL in Post Content Globally using phpMyAdmin

  1. Login to phpMyAdmin and select your database
  2. Click the SQL tab to write new fresh query on selected database.
  3. Enter the following in the run SQL Query text box –
  4. Click Go to process the changes and update your SQL database

[box]
Kindly replace http://www.old-link.com and http://www.new-link.com with your actual information.[/box]