title: Multiple LIKE statements in query
body: <p>I am currently working on search engine for baking recipes, the site returns recipes based on the ingredients that the user has. I only want to return the recipes where BOTH ingredients are present in, in some kind of form. I tried the following SQL statement, but i cant seem to get it to work propperly with the AND in between, it works fine with OR or without the AND.</p>
  
  <pre><code>SELECT * FROM ingredients WHERE name LIKE '%flower%' AND name LIKE '%egg%'
  </code></pre>
  
  <p>It doenst throw any errors it just says that there arent any results, which is odd as the first recipe has already bot ingredients in it.</p>
  
  <p>I hope someone can help me out! Thanks in Advance</p>