Select all users that are in a secondary usergroup in MySQL

Select all users that are in a secondary usergroup in MySQL

Compatible XF 1.x 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. Log in or register now.
Author
ThemeHouse
Views
56
First release
Last update
Rating
0.00 star(s) 0 ratings

More resources from ThemeHouse

Top