Mysql find_in_set problem

prasath03 · #1 (**permalink**) 09-17-09, 06:41

Dear All,

Since find_in_set only searches by a single string, like:

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

is there any way to achieve functionality like I 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'.

Thanks in Advance

Prasath.

r937 · #2 (**permalink**) 09-17-09, 07:32

Code:

WHERE FIND_IN_SET('a','a,b,c,d') > 0
   OR FIND_IN_SET('b','a,b,c,d') > 0
   OR FIND_IN_SET('c','a,b,c,d') > 0

Internet Services

Web Development

Digital Marketing

Consumer Tech