select user records by secondary group
 

I want to select all user records that are members of secondary group X. Is there any fancy SQL that would allow me to directly select these records? Or should I select all user records and parse through them with the is_member_of() function?

http://dev.mysql.com/doc/mysql/en/String_functions.html

Functions which may be of use to are FIND_IN_SET and SUBSTR.

This works (only tested under MySQL 4.0.21):

[sql]
SELECT *
FROM user
WHERE FIND_IN_SET(2, membergroupids)
[/sql]

FIND_IN_SET seems to work. thx