May 5, 2015 in Technical Problems
I have certain set of moderators, admins, and users that I wish to batch unsubscribe from newsletter option. They all are using same domain email ID. Can I unsubscribe them from sql quickly? Thanks.
Make sure you add in your table prefix and replace email domain with actual domain:
UPDATE core_members SET allow_admin_mails = 0 WHERE email LIKE '%@domain.com';
Thanks Jim, perfect solution. Just changed core_members to members table.
This topic is now archived and is closed to further replies.
Started September 8
Started April 7
Started Monday at 08:54 AM