XF 1.5 Receive Site Mailing Setting in Database?

OK, let me explain in a little more details what it is I would like to do.

I want to execute a SQL query that will change the Receive Site Mailings setting to off for members of a particular user group (#19).

Thanks to anyone who is able to assist.
 
OK, I'm trying this

Code:
UPDATE xf_user_option
SET receive_admin_email = 0
WHERE user_group_id = 19

But getting this error message:

#1054 - Unknown column 'user_group_id' in 'where clause'

Is it because user_group_id is in another database table?
 
Back
Top Bottom