UPDATE query not updating all columns

Discussion in 'Databases' started by ridesign, Feb 20, 2009.

  1. #1
    I am trying to update 3 columns to be blank, when I run the query only 1 columns are being set to NULL and the site and e1remains unchanged.
    d1 being changed to NULL

    UPDATE links SET d1=NULL AND e1=NULL AND site=NULL WHERE site LIKE '%zoo1%'
    Code (markup):

     
    ridesign, Feb 20, 2009 IP
  2. dowhile

    dowhile Active Member

    Messages:
    37
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    93
    #2
    Instead of "AND" put ",".
     
    dowhile, Feb 20, 2009 IP
    ridesign likes this.
  3. ridesign

    ridesign Peon

    Messages:
    294
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    thanks works great
     
    ridesign, Feb 21, 2009 IP