Jason,

While you are cranking out sql statements I would like to do 2 things:

1) I'd like a statement I can run regularly to set post_reply_notify = 0 on all posts in the forum_Post table for all users where user_email is "invalid@email.address" in the forum_User table.

I was thinking of the statement below but I'm not sure it will check against the forum_User table:

UPDATE forum_Post SET post_reply_notify = 0 WHERE user_email IS "invalid@email.address";

2) I would like to remove all subscriptions from forum_ForumSubscriber for all users where user_email is "invalid@email.address" in the forum_User table.

I'm know very little to nothing about sql so I thought I'd ask. I unfortunately have a lot of users with invalid email addresses that came over with a migration and my mail server is being flooded with bounced notifications to this address.

Thanks for the help!

Safe swoops
Sangiro