So now that I have multiple places where I link to Amazon.com 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.