Announcement

Collapse
No announcement yet.

Query to remove secondary Usergroups?

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Query to remove secondary Usergroups?

    I'm looking for a query to remove all the applied secondary usergroups from users within a certain primary usergroup. Thank in advance.

  • #2
    UPDATE user
    SET membergroupids = ''
    WHERE usergroupid = X

    Where X is the primary usergroupid.

    Comment


    • #3
      Thnx!

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X