Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
Gauravk Posted May 5, 2015 Posted May 5, 2015 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.
Jim M Posted May 6, 2015 Posted May 6, 2015 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';
Gauravk Posted May 8, 2015 Author Posted May 8, 2015 Thanks Jim, perfect solution. Just changed core_members to members table.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.