Mass update links with phpmyadmin

Discussion in 'Blogging' started by 3kaday, Aug 24, 2010.

  1. 3kaday

    3kaday Regular Member

    Joined:
    Apr 28, 2009
    Messages:
    218
    Likes Received:
    53
    Location:
    London, EUSSR
    I have several blogs which have amazon content posted with wprobot on 1000's of posts.

    I need to change all the tags in the posts like a mass find and replace so that for example

    hxxp://amazon.co.uk/blahblah?tag=mysite-21

    becomes

    hxxp://amazon.co.uk/blahblah?tag=mysite2-21

    I only want to change the tag, not the whole link.

    Anyone know how to do this in php my admin or can point me in the right direction?

    Thanks