XF 1.1 Query to change receive admin email based on list of emails

[Brent W]

If I have a list of emails is there a query that I can run that will change all of those emails so that they don't receive admin emails?

 

[Jake Bunce]

UPDATE xf_user_option AS uo
SET uo.receive_admin_email = 0
WHERE (
	SELECT u.user_id
	FROM xf_user AS u
	WHERE u.user_id = uo.user_id
	AND u.email IN ('blah@blah.com', 'blah4444@blah.com')
);