XF 2.0 How to set "Watched" Content to "yes, with email" for all users


Well-known member
After importing my IPBoard database, all the users were set to "No" for receiving email/alerts for content they create or interact with. Are there a couple of SQL Queries I could run to change them from "No" to "Yes, with email". I have set the registration for future users to this, but all of my imported users have "No" listed at present.

watch content.png