Skip to content

Instantly share code, notes, and snippets.

@iovino

iovino/gist:6299293

Created August 21, 2013 19:50
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save iovino/6299293 to your computer and use it in GitHub Desktop.
Save iovino/6299293 to your computer and use it in GitHub Desktop.
Download ZIP
This query will return true if the selected usergroup is marked as the banned group:
Raw
gistfile1.sql
SELECT IF(usergroup.genericoptions & 32, 0, 1) AS is_banned_group
FROM usergroup as usergroup
WHERE usergroup.usergroupid = 8;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment