title: How to match comma separated string against comma separated MySQL field
body: <p>I’m trying to match comma separated string against comma separated MySQL field. This should match one more comma separated text.</p>
  
  <p>Example</p>
  
  <p>String = <code>apple, pineapple, grapes</code></p>
  
  <p>MySQL field = <code>mango, oranges, apple</code></p>
  
  <p>I tried <code>MySQL IN</code> but it only works if string exactly match the MySQL filed or if there is only one item in the string</p>
  
  <pre><code>SELECT * FROM table1 WHERE field_1 IN (‘string’)
  </code></pre>
  
  <p>Also tried <code>FIND_IN_SET</code> without any luck. Can anyone tell me how to achieve this? Appreciate your help. </p>