Query to remove secondary Usergroups?

[GearTripper]

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

[Jake Bunce]

UPDATE user
SET membergroupids = ''
WHERE usergroupid = X

Where X is the primary usergroupid.

[GearTripper]

Thnx!