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]
