Changing affiliate codes in WP post

cd34 · 2009-05-21, 11:13 AM

Code:

create table wp_postsbk select * from wp_posts;
update wp_posts set post_content=replace(post_content,'oldstringtoreplace','newstringtouse');

if you mess up:

Code:

delete from wp_posts;
insert into wp_posts select * from wp_postsbk;

nate · 2009-05-21, 08:15 PM

Quote:

Originally Posted by cd34

Code:

create table wp_postsbk select * from wp_posts;
update wp_posts set post_content=replace(post_content,'oldstringtoreplace','newstringtouse');

Its scary what some people can quote off the top of their head.

LD · 2009-05-21, 11:37 PM

Quote:

Originally Posted by nate

Its scary what some people can quote off the top of their head.

cd34 knows his shit!

Howling, that plug worked like a charm! It took about 5 seconds...no problems whatsoever.

2009-05-21, 11:13 AM	#1
cd34 a.k.a. Sparky Join Date: Sep 2004 Location: West Palm Beach, FL, USA Posts: 2,396	Code: create table wp_postsbk select * from wp_posts; update wp_posts set post_content=replace(post_content,'oldstringtoreplace','newstringtouse'); if you mess up: Code: delete from wp_posts; insert into wp_posts select * from wp_postsbk; __________________ SnapReplay.com a different way to share photos - iPhone & Android