1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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