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

Login to phpMyAdmin and select your database
Click the SQL tab to write new fresh query on selected database.
Enter the following in the run SQL Query text box -

UPDATE wp_posts SET post_content = REPLACE

(

post_content,

'http://www.old-link.com',

'http://www.new-link.com'

);

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]