Zane Posted February 18, 2010 Share Posted February 18, 2010 Lets say I have a column (called group) in a table called clients.. and I have a table for these groups. In the aforementioned column I have a comma separated list of indexes, relative to the table group. How can I select ALL clients from a certain group? Say for instance I want all clients with a group ID of at least 5. Is there a function to run through a comma separated list..? Something similar to the way IN works. So then I could be like SELECT * FROM clients WHERE group IN (5) Obviously the code above won't work (or will it).... what should I do? Quote Link to comment Share on other sites More sharing options...
mapleleaf Posted February 19, 2010 Share Posted February 19, 2010 I think you are looking for FIND_IN_SET(5, group) Quote Link to comment Share on other sites More sharing options...
Zane Posted February 19, 2010 Author Share Posted February 19, 2010 I ended up created a "joining table", as suggested by cags in the IRC Chat. So in the end I would have ... a table for: Clients Groups Members // The Joining Table.. consisting of a memberID, clientID, & groupID Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.