Check out example codes for "mysql in clausule string array". It will help you in understanding the concepts better.

Code Example 1

SELECT (SELECT GROUP_CONCAT(user.name) 
 FROM user WHERE instr(concat(' ,',list.list,','),concat(',',user.id,',')) > 1
 ) 
FROM list

Learn ReactJs, React Native from akashmittal.com