Changing affiliate codes in WP post

[cd34]

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

if you mess up:

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