Bulk Editting in WP.

W

webhandler

Newbie

May 10, 2013

25

2

• Apr 7, 2014

• #1

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.

 

dionysus

Junior Member

Dec 15, 2008

105

32

• Apr 8, 2014

• #2

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/

 

S

SEOnetic

Senior Member

May 21, 2012

992

120

• Apr 9, 2014

• #3

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');

 

bluehatface

Regular Member

Oct 19, 2013

290

125

• Apr 10, 2014

• #4

/\ /\ /\ This. Direct SQL manipulation is the best way to go for this. Just backup your database first (you never know!)