How do I use a LIKE or CONTAINS clause in SQL on the same row?

     

In my project you can list the ingredients you have and search for recipes that can be made with those ingredients. Here's my sample SQL query:  heres the database https://i.imgur.com/LgZ0WMD.png  i want to get the matching list.


SELECT recipes_Name   FROM tblrecipes  INNER JOIN tblingredients  ON tblrecipes.recipes_ID = tblingredients.ingredients_ID  WHERE ingredients_name = variable1 AND variable2 AND variable3  

Why is this query not working?

  
"
answer1
  
  

You can use in clause:


SELECT recipes_Name   FROM tblrecipes  INNER JOIN tblingredients  ON tblrecipes.recipes_ID = tblingredients.ingredients_ID  WHERE ingredients_name in (variable1