XF 1.2 Set to 'No' Watch threads when creating or replying

[RoyalRumble]

Hi there,

I've just gone live with a migration from vB to XF - all going well with the exception of complaints over members receiving tons of alerts.

I've disabled 'Watch threads when creating or replying' on registration, but is there anyway (Query perhaps?) to disable this feature across all current accounts? I would rather it be 'Opt In' rather than 'Opt Out'.

Thanks

 

[Chris D]

UPDATE xf_user_option
SET default_watch_state = ''

 

[RoyalRumble]

Thanks a lot @Chris Deeming

 

[Mike]

FWIW, the value comes from a roughly equivalent setting in vB, so that is something they would've had set before.