-
Help with SQL UPDATE
I need help with updating multiple rows in a table if the email address equals 'this e-mail' or 'that e-mail'
What I have for one query:
Code:
UPDATE `email_table` SET `email_status` = "0" WHERE `email_address` = "user@domainname.com"
I tried OR but it updated the whole table. I can't seem to type in the right search terms to find an answer.
As always, thanks in advance!
-
Here's the correct syntax - finally figured it out!
Code:
UPDATE `email_table` SET `email_status` = "0" WHERE `email_address` = "user@domainname.com" OR `email_address` = "anotheruser@domainname.com"