"Receive Email from Administrators": Which members have set this to "no"?

[Simon Lloyd]

You'd need to know which option in the user table is for recieve admin emails and then get the matches like this

PHP Code:

SELECT * 
FROM `user`
WHERE substr(`options`, 5, 1) = '1' 


So this one says show all the people who have the option set for 1 at position 5 in the string of options, so maybe in phpmyadmin the options column looks like 432516780 as you can see in this example position 5 shows 1 so it would be a match.

I dont know what the criteria is for creating the options list or how they arrive at the figures, if i did i could help further

--------------- Added [DATE]1357315487[/DATE] at [TIME]1357315487[/TIME] ---------------

Originally Posted by Brandon Sheley

I'd check the user table and see what field that is, then something like
select * from user where admin_emails = no

Unfortunately that column doesn't exist