WordPress.org

1. Emanon
   Member
   Posted 5 years ago #

   I've recently had to change the domain of my blog, so all links in posts and comments are dead. The vast majority of them are in-blog posts, so a simple search and replace could set most of my issues straight.

   I want to search all my tables for "old.url.com/whateverfile.xxx" and have it replaced with "new.url.net/whateverfile.xxx".

   Running PHPMyAdmin 2.5.3 - can someone tell me (or point me to some instructions) how to accomplish this?

2. moshu
   Member
   Posted 5 years ago #

   Maybe this plugin?
   http://wordpress.org/support/topic/11680?replies=6#post-164257
   (found by putting "search and replace" in the searchbox!)

3. Emanon
   Member
   Posted 5 years ago #

   I ended up reading the docs at dev.mysql.com/doc/ and wrote this query to do the job;

   UPDATE wp_posts SET post_content = replace(post_content,"searchstring","replacewiththis");

   Thanks for the tip though!

   (and yes. I really should've searched. My apologies!)

Topic Closed

This topic has been closed to new replies.