Announcement

Collapse
No announcement yet.

SQL query help

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Doug Nelson
    replied
    Thank you very much.

    Leave a comment:


  • Jake Bunce
    replied
    This should do it:

    SELECT email
    FROM user
    WHERE (usergroupid = 2 OR usergroupid = 3)
    AND NOT(options & 16)

    Leave a comment:


  • Doug Nelson
    started a topic SQL query help

    SQL query help

    This is almost certainly the wrong forum for this, so my apologies and please move it as appropriate.

    I'm looking for the SQL query to output a list of user email addresses from only registered and awaiting confirmation users that have opted out of admin emails.

    Thanks in advance.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X