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 FIND_IN_SET(gid,ugid) > 0; > > +------+---------+-----------------------+ > > | gid | ugid | FIND_IN_SET(gid,ugid) | > > +------+---------+-----------------------+ > > | 1 | 1,2,3,4 | 1 | > > | 2 | 1,2,3,4 | 2 | > > | 3 | 1,2,3,4 | 3 | > > | 2 | 2,5,6 | 1 | > > | 3 | 3,4,5 | 1 | > > | 9 | 7,4,9 | 3 | > > +------+---------+-----------------------+ > > 6 rows in set (0.00 sec) > > > > Et voilà. > > > > Hope that helps > > Brilliant - I wasn't aware of FIND_IN_SET, and that's exactly what I > needed. Amazing! Thank you very much indeed - merci beaucoup > Mathias, vraiment. > > -- > Will > -- The Corridor of Uncertainty -- > -- http://www.cricket.mailliw.com/ > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > Hope that helps :o) Mathias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
