Need help writing an SQL query to remove bounced emails

[howarde]

Hi,

I have a list of bounced emails, and I want to change the receive admin email option to "no" for these users, by running an update query on the user table.

I understand, I can change those options with this part:

UPDATE user SET options = options - 16 WHERE options & 16 AND userid = xxxx

However... I'm having a hard time coming up with the query to cross-reference the bounced email list. I figure I can import the bounced emails to a table called, "bounce" and essentially, I want to

UPDATE user (like above)

WHERE bounce.email = user.email

however... it's not that easy (for me) - maybe there's some mysql experts that could point me in the right direction?