• 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

Select all users that are in a secondary usergroup in MySQL

Mike Creuzer

Well-known member
#1
Mike Creuzer submitted a new resource:

Select all users that are in a secondary usergroup in MySQL - Simple query to grab users of a certain secondary usergroup

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 find_in_set(X,secondary_group_ids)
Where X is the secondary group id you want.
Read more about this resource...