search on multiple column with multiple value in mysql

Question

select * from vis_provider where
    FIND_IN_SET(('German'),CONCAT(
                DoctarLanguage1,',',
                DoctarLanguage2,',',
                DoctarLanguage3,',',
                DoctarLanguage4,',',
                DoctarLanguage5,',',
                DoctarLanguage6))

this Mysql query is working I want something like this

select * from vis_provider where
    FIND_IN_SET(('German','French'),CONCAT(
                DoctarLanguage1,',',
                DoctarLanguage2,',',
                DoctarLanguage3,',',
                DoctarLanguage4,',',
                DoctarLanguage5,',',
                DoctarLanguage6));

What is the issue you are having? Also please include the table structure. — Jen R, Apr 25 '17 at 14:46
this has already been solved here: http://stackoverflow.com/questions/5015403/mysql-find-in-set-with-multiple-search-string — Carolina Centeio Jorge, Apr 25 '17 at 14:59
Possible duplicate of [MySQL find\_in\_set with multiple search string](http://stackoverflow.com/questions/5015403/mysql-find-in-set-with-multiple-search-string) — Alex, Apr 25 '17 at 15:10

score 0 · Answer 1 · answered Apr 25 '17 at 14:56

0

select * 
from vis_provider 
where  FIND_IN_SET( 'German' , CONCAT( ... ) )
   OR  FIND_IN_SET( 'French' , CONCAT( ... ) )

answered Apr 25 '17 at 14:56

Juan Carlos Oropeza

47,252
12
78
118

I am doing this:- select * from vis_provider where (DoctarLanguage1 in('Spanish','German')) or (DoctarLanguage2 in('Spanish','German')) or (DoctarLanguage3 in('Spanish','German')) or (DoctarLanguage4 in('Spanish','German')) or (DoctarLanguage5 in('Spanish','German')) or (DoctarLanguage6 in('Spanish','German')) can We have diffrent ways to write that code; – omi gupta Apr 26 '17 at 06:22

search on multiple column with multiple value in mysql

1 Answers1