mysql find_in_set

[ebobnar]

Since find_in_set only searches by a single string, like:

find_in_set('a', 'a,b,c,d');

is there a way to achieve functionality like you would if find_in_set
could search by multiple strings, such as:

find_in_set('a,b,c', 'a,b,c,d');

This would return true if a OR b OR c were found in the set 'a,b,c,d'.

I realize that you could use a chain of OR's, but only if you knew the
number of strings that you would be searching by (in my case, I
don't).

Thanks

Esoos