[wp-hackers] Re: Subscribe to Comments plugin

spencerp theone.andonly.mr.awesome at gmail.com
Sat May 10 11:44:06 GMT 2008

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..

More information about the wp-hackers mailing list