Updating multiple columns in a single query

Databases
1

I get the following error when trying to run this query:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘set clicked = ‘0’ WHERE clicked = 1 and alerts = 1’ at line 1

update searches set alerts = ‘0’, set clicked = ‘0’ WHERE clicked = ‘1’ and alerts = ‘1’;

Any ideas? Thanks!

2

You only have to declare SET once. Remove the second “set” and you should be good to go.