1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Mass update links with phpmyadmin

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

  1. 3kaday

    3kaday Regular Member

    Joined:
    Apr 28, 2009
    Messages:
    216
    Likes Received:
    51
    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