ktsangop Junior Poster in Training 131 posts since Jan 2010 Reputation Points: 23 [?] Q&As Helped to Solve: 1 [?] Skill Endorsements: 0 [?] •Community Member 0 2 Years Ago Hello everyone! Is it possible to write a query which does the following : UPDATE db.table SET col1 = 1 WHERE col2='something' AND col3 IN ('a','b','c') ELSE SET col1 = 0 Meaning that the rows that don't match the where conditions will also be updated to another value. Note that db.table has no primary key, but foreign key only. :S edit : I am looking for a single query of course! Thanks in advance!