1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Select all users that are in a secondary usergroup in MySQL

Simple query to grab users of a certain secondary usergroup

  1. Mike Creuzer
    Compatible XF Versions:
    • 1.0
    • 1.1
    • 1.2
    • 1.3
    • 1.4
    XenForo stores secondary user groups in a varbinary list. You might not see this list in human-readable form depending on your version of phpMyAdmin or otherwise in the browse so it might look confusing.

    If you need to grab all users that are in a secondary usergroup, here is the query to enter to get them.

    Code:
    SELECT * FROM xf_user WHERE...
    You do not have permission to view the full content of this resource.
    ClundXIII, sinucello, Kirk and 3 others like this.