Last month Text Link Ads (TLA) started using tinyurl.com to shorten and secure it’s affiliate referral links and had asked TLA publishers to update their affiliate links before the end of the month.
I have used my TLA affiliate links in many posts and so I had not updated my posts until I found an easier method thanks to Liew who has explained on how to update all the old TLA affiliate links in one shot (WordPress only) using Mass String Replace in MySQL.
Using the below MySQL query, I was able to update all my posts containing Text Link Ads affiliate links in a few seconds:
UPDATE `wp_posts` SET `post_content` = REPLACE(`post_content`, "OLD_TLA_AFF", "NEW_TLA_AFF")
Please note that OLD_TLA_AFF should be replaced with your old Text Link Ads affiliate URL and NEW_TLA_AFF replaced with the new Text Link Ads affiliate URL.
If you have not signed up for Text Link Ads yet, do try them out and make money by selling links on your blog. Also read my Text Link Ads review and my post on how to make more money with Text Link Ads.