1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Bulk Editting in WP.

Discussion in 'Blogging' started by webhandler, Apr 7, 2014.

  1. webhandler

    webhandler Newbie

    Joined:
    May 10, 2013
    Messages:
    25
    Likes Received:
    2
    Home Page:
    Hi I have about 500,000 pages that need to be editted on a wordpress blog. Regex cant do it and I just wanted to know what are some of the ways you can edit so many WP pages all at once or in bulk for that matter.
     
  2. dionysus

    dionysus Junior Member

    Joined:
    Dec 15, 2008
    Messages:
    104
    Likes Received:
    31
    The following link may help, other than that, google is your friend. Lots of results for bulk edit in wordpress

    Code:
    http://www.hongkiat.com/blog/how-to-search-and-replace-wordpress-in-blog-post/
     
    • Thanks Thanks x 1
  3. SEOnetic

    SEOnetic Senior Member

    Joined:
    May 21, 2012
    Messages:
    995
    Likes Received:
    120
    Here is an mysql code that can search and replace text.
    Code:
    UPDATE wp_posts SET post_content = REPLACE (  
    post_content,  
    'Item to replace here',  
    'Replacement text here');  
    
     
  4. bluehatface

    bluehatface Regular Member

    Joined:
    Oct 19, 2013
    Messages:
    232
    Likes Received:
    98
    Location:
    Here
    /\ /\ /\ This. Direct SQL manipulation is the best way to go for this. Just backup your database first (you never know!)