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!
You only have to declare SET once. Remove the second "set" and you should be good to go.