Sorry, I don’t know why I didn’t just add it. I found it after moving my blog and having to revert all the short links to the originals.
Log into phpmyadmin
Select the correct WP database.
Select the SQL tab
Paste in the following –
UPDATE wp_posts SET post_content = REPLACE (post_content, ‘httx://oldlink.com’, ‘httx://newlink.com’);
It automatically swaps out all the links as requested.
So far I’ve only used it as mentioned above. But it could obviously be used on specific links to test out a change from PPS to Rev Share or to test certain tours from all existing posts etc. I plan to try this out in a couple of months once I’ve built up some good traffic for a specific affiliate sponsor. It’s a great way to change all the posts in seconds rather than having some on one method and starting up with another.
Does that make sense? Sorry it’s very late here and I’m almost falling asleep in my chair.