PDA

View Full Version : SQL query to check how many have receive email from admins enabled?

BamaStangGuy
06-17-2006, 10:57 PM
Can someone please give me a sql query to show me how many of my members have the "Receive email from administrators" checked on my board? :)

Thanks a bunch.
Alan @ CIT
06-18-2006, 08:17 AM
"SELECT count(userid) FROM user WHERE options & 16"

Thanks,
Alan.