XF 1.4 Disable multiple members' "Receive site mailings" option at once

[markku]

With the following query (thanks @Andy.N) one can put several users into the Email invalid (bounced) state.

update `xf_user`
set user_state = 'email_bounce'
where email IN ('email1@domain.com', 'email2@domain.com')

The question is, does anyone know of a similar query but which would disable the accounts' "Receive site mailings" option that are associated with the said emails?

Is it possible to do with a simple query?

 

[Valhalla]

UPDATE xf_user_option AS user_option
     SET user_option.receive_admin_email='0'
WHERE user_option.user_id IN
     (SELECT user_id FROM xf_user WHERE email IN ('', ''))