SQL query to remove existing subscriptions?

[ibrian]

I'm trying to tidy up an old forum, but there are a lot of inactive members who have the "Receive activity summary email" option checked, and I'd like to unchecked it to reduce bounced emails.

I presume there must be a simple SQL query I can run in phpmyadmin to change the option for all members from checked to unchecked.

Could anyone advise what this might be, please?

Many thanks for any replies.

Continue reading...