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? Link to comment https://forums.phpfreaks.com/topic/192545-multiple-index-references/ 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) Link to comment https://forums.phpfreaks.com/topic/192545-multiple-index-references/#findComment-1014587 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 Link to comment https://forums.phpfreaks.com/topic/192545-multiple-index-references/#findComment-1014705 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.