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.
edit : I am looking for a single query of course!
Thanks in advance!