MySQL – Change 1,000 Joomla User Receive System Emails To No

Problem: Client had accidentally set all User’s Receive System Emails to YES. Receive System Emails are for Super Users/Webmaster only – not for 1,000 members.

Solution: Use phpMyAdmin to select and confirm that all 1,000 Joomla Users whose Receive System Emails are set to sendMail=1 (1=Yes)

SELECT *
FROM `xxxx_users`
WHERE sendemail=1

Then, update all Receive System Emails from 1 (Yes) to 0 (zero; No)

UPDATE `xxxx_users`
SET `sendEmail` = replace(sendEmail, ‘1’, ‘0’)

Note: swap out the “xxxx” for your database’s prefix_

Very helpful source: How to find who is receiving Joomla system emails – Dart Creations