Phpmyadmin Query

Discussion in 'MySQL' started by iamsgf, Feb 27, 2010.

0
  1. #1
    Hi,

    I am not a programmer so am looking for a quick help!!

    I need a sql query that I can run in phpmyadmin that will search all tables for a domain eg domain1.com and replace it with domain2.com

    Can anyone help me.

    thanks
     
    iamsgf, Feb 27, 2010 IP
  2. vic_msn

    vic_msn Well-Known Member

    Messages:
    2,233
    Likes Received:
    125
    Best Answers:
    0
    Trophy Points:
    155
    #2
    something like this
    UPDATE [table_name] SET [column_name] = 'domain2.com' WHERE [column_name] = 'domain1.com'
    PHP:
     
    vic_msn, Feb 27, 2010 IP
    iamsgf likes this.
  3. iamsgf

    iamsgf Active Member

    Messages:
    982
    Likes Received:
    17
    Best Answers:
    0
    Trophy Points:
    85
    #3
    thanks... you are a star... saved me hours of work
     
    iamsgf, Mar 3, 2010 IP