In the following simple solution, I will show you how to replace all global occurrences of a URL link (or any other text) within your WordPress post content using SQL Search and Replace Query from phpMyAdmin. This is useful if you need to change a link or text that might appear in more than one post, without going in and manually editing each post by hand to reflect the new link or text.
In the following simple solution, I’ll show you how to Search and Replace SQL database information from PhpMyAdmin. This SQL query method is extremely helpful when you need to replace multiple text strings and do not wish to export the entire database just to make those changes. With the SQL Search and Replace (SQL Query Method) the database changes can be made instantly on the fly.