Gauravk Posted May 5, 2015 Share 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. Link to comment Share on other sites More sharing options...
Jim M Posted May 6, 2015 Share 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'; Link to comment Share on other sites More sharing options...
Gauravk Posted May 8, 2015 Author Share Posted May 8, 2015 Thanks Jim, perfect solution. Just changed core_members to members table. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.