Help with SQL UPDATE

[rlhanson]

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:

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!

[rlhanson]

Here's the correct syntax - finally figured it out!

UPDATE `email_table` SET `email_status` = "0" WHERE `email_address` = "user@domainname.com" OR `email_address` = "anotheruser@domainname.com"