Take the 2-minute tour ×  I find that find_in_set only search by
a single string :-  find_in_set('a', 'a,b,c,d')  In the above
example, 'a' is the only string used for search.  Is there any
way to use find_in_set kind of functionality and search by
multiple strings, like :-  find_in_set('a,b,c', 'a,b,c,d')  In
the above example, I want to search by three strings 'a,b,c'.
One way I see is using OR  find_in_set('a', 'a,b,c,d') OR
find_in_set('b', 'a,b,c,d') OR find_in_set('b', 'a,b,c,d')  Is
there any other way than this?  share|improve this question i
met this problem today, thanks for you question and it saved my
day :) –  尤川豪 Feb 6 at 2:50  3 Answers 3  up vote 7 down vote
accepted  The MySQL function find_in_set() can search only for
one string in a set of strings.  The first argument is a string,
so there is no way to make it parse your comma separated string
into strings (you can't use commas in SET elements at all!). The
second argument is a SET, which in turn is represented by a
comma separated string