Resource icon

XF 1 Tip select all users that are in a secondary usergroup in MySQL

ENXF NET

Administrator
Staff member
Administrator
Moderator
+Lifetime VIP+
S.V.I.P.S Member
S.V.I.P Member
V.I.P Member
Collaborate
Registered
Joined
Nov 13, 2018
Messages
19,121
Points
823

Reputation:

LQD submitted a new resource:

elect all users that are in a secondary usergroup in MySQL - Select all users that are in a secondary usergroup in MySQL

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:
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...
 
Top