matching any values of a set to any values of another set

2004-06-27 Thread tidalx
Hi, i am trying to match a set of values to another set of values, and to return true if any of the values of one set matches any values of the second set. Something like SELECT * FROM listings WHERE FIND_IN_SET('Mastercard,Visa', 'AMEX, Cash, Mastercard, Visa') 0; which I don't think

Re: matching any values of a set to any values of another set

2004-06-27 Thread Michael Stassen
tidalx wrote: Hi, i am trying to match a set of values to another set of values, and to return true if any of the values of one set matches any values of the second set. Something like SELECT * FROM listings WHERE FIND_IN_SET('Mastercard,Visa', 'AMEX, Cash, Mastercard, Visa') 0; SELECT * FROM