title: MySQL WHERE with comma separated string
body: <p>I have seen some related, but have been unable to get it to work correctly. Hopefully this is easy for someone!</p>
  
  <p>I basically am receiving values from an API in a comma separated string. I am trying to use a WHERE clause where I can use this string. Let me provide example.</p>
  
  <p><strong>Edit</strong>
  A user fills out a form and the data is saved into a table, where one of the columns is called "Allergies". I am now looking to use that column which could look like <code>"Egg,Milk,Peanuts".</code></p>
  
  <p>I have built a query that will return recipes for the user and this needs to take into account each of the values in the string.</p>
  
  <p>So I can manually have this work correctly by using this syntax:</p>
  
  <pre><code>...
  WHERE a.AllergyName = 'Egg' || a.AllergyName = 'Milk' || a.AllergyName = 'Peanut'
  ...
  </code></pre>
  
  <p>Does anybody know how I can dynamically do this?</p>