[resolved] Search & Replace in PHPMyAdmin? (3 posts)

  1. Emanon
    Posted 9 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
    Posted 9 years ago #

    Maybe this plugin?
    (found by putting "search and replace" in the searchbox!)

  3. Emanon
    Posted 9 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.

About this Topic