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):