SQL query for updating user.displaygroupid

[knimrod]

I need a query to update all members who belong to a certain usergroup (42) so that their displaygroupid = that usergroup (42).

This works:

update user set displaygroupid = 42 where membergroupids = 42

but it only checks the first group in the membergroupids field. If the member also belongs to other groups with lower ids, it doesnt work. Is there a way to loop through each member's membergroupids field for the match?

Any help? Thanx.

[knimrod]

Nevermind... I figured it out. For those interested it's:

update user set displaygroupid = 42 where find_in_set(42, membergroupids)