[wp-hackers] Re: Subscribe to Comments plugin

[spencerp]

spencerp wrote:
> I figured, it shouldn't be too hard.. to auto subscribe everyone to 
> any posts they've commented on .. despite their earliest commented 
> dates.../ despite the plugin's installation date...

Thanks to Jeremy Visser... !!!
UPDATE wp_comments SET comment_subscribe = 'Y' WHERE 1 = 1;

This sets all comments to "Y" in the wp_comments table..  change the 
table name accordingly to yours.. This sets all comments to Subscribed..