WordPress.org

1. pro102
   Member
   Posted 3 years ago #

   We have hyperlinks to a given URL(call it #1) that we need to update to URL #2. URL #1 is found in numerous posts and pages and need to change to #2. However, #2 needs to remain in place for other needs, so a simple redirect is not a solution.

   Is there a SQL query in phpmyadmin that would allow to say REPLACE all URL1 links in pages or posts, to URL2? Am no SQL expert so guidance much welcome.

2. iridiax
   Member
   Posted 3 years ago #

   Is there a SQL query in phpmyadmin that would allow to say REPLACE all URL1 links in pages or posts, to URL2?

   Try this plugin: http://wordpress.org/extend/plugins/search-and-replace/

3. pro102
   Member
   Posted 3 years ago #

   Thanks Iridiax! Just installed and tried, and it seems to have worked phenomenally well. Need to make all is OK but after checking 5 random pages, it's all good. Had no idea of the existence of this plugin. I'll also say kudos to the author on the plugin page.

Topic Closed

This topic has been closed to new replies.