Searching IN a comma separated list

2005-06-25 Thread W Luke
Hi, Have struggled with this all day, and didn't know where else to ask. If it's not appropriate to the list, I apologise - and advice or pointers would be brilliant, as my head is now hurting! So here's the situation: 3 tables. f_u_groups f_groups and f_images f_u_groups contains the user's

Re: Searching IN a comma separated list

2005-06-25 Thread Mathias
Selon W Luke [EMAIL PROTECTED]: Hi, Have struggled with this all day, and didn't know where else to ask. If it's not appropriate to the list, I apologise - and advice or pointers would be brilliant, as my head is now hurting! So here's the situation: 3 tables. f_u_groups f_groups and

Re: Searching IN a comma separated list

2005-06-25 Thread W Luke
On 25/06/05, Mathias [EMAIL PROTECTED] wrote: I then write you this query which should give you the idea, and i think the solution : mysql select gid,ugid,FIND_IN_SET(gid,ugid) from groups,groupsList - where FIND_IN_SET(gid,ugid) 0; +--+-+---+ | gid |

Re: Searching IN a comma separated list

2005-06-25 Thread Mathias
Vous ĂȘtre le bienvenue :o) Selon W Luke [EMAIL PROTECTED]: On 25/06/05, Mathias [EMAIL PROTECTED] wrote: I then write you this query which should give you the idea, and i think the solution : mysql select gid,ugid,FIND_IN_SET(gid,ugid) from groups,groupsList - where