Text Link Ads (TLA) have begun using TinyURL.com to shorten and secure its affiliate referral links.
TLA publishers are advised to update their TLA affiliate links immediately because the old affiliate URLs will no longer work after August 2007.
If you only have TLA affiliate links on your website template, it is easy to update the URLs. However, if you have a couple of posts with TLA affiliate links in the post body like me (Text Link Ads Tips, it could be troublesome to dig them out and edit one by one.
Here I show you how to update all the old TLA affiliate links in one shot (WordPress only) using Mass String Replace in MySQL:
[sql]UPDATE `wp_posts` SET `post_content` = REPLACE(`post_content`, “OLD_TLA_AFF”, “TINYURL_TLA_AFF”)[/sql]
OLD_TLA_AFF — your old Text Link Ads affiliate URL.
TINYURL_TLA_AFF — the new Text Link Ads affiliate URL using TinyURL.com you received.
Using the MySQL query, I updated all the posts containing TLA affiliate links in 1 minute. Fast, clean, and easy!
By the way, here I assume you know how to run a MySQL query. Contact me if you need help.