Changing Amazon Affiliates ID

So now that I have multiple places where I link to items using my affiliates ID, I’ve decided to create multiple Amazon affiliates ID to track where things were coming from.

I knew there was a way to mass edit strings in my blog posts and a quick search resulted in: How to Find & Replace Data in MySQL

To find a string in a certain field and replace it with another string:

update [table_name] set [field_name] = replace( [field_name], '[string_to_find]', '[string_to_replace]' );

So a quick update wp_posts set `post_content` = replace( `post_content`, 'krudoethekrue-20', 'krunk4everblog-20' ); did the trick.

Now I’ll be able to track if people are coming through my HD-Trailers site, my HD-Trailers blog, or my Krunk4ever! blog.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.