title: SQL - Select recipes that share similar number ingredients from MySQL database?
body: <p>I have three tables. recipes, ingredients and recipeingredients. recipeingredients contains ri_recipeid and ri_ingredientid and each record is an ingredient in a recipe.</p>
  
  <p>I want to randomly select a set of recipes that all contain, lets say, at least 3 of the same ingredients. How would I go about doing this?</p>
  
  <p>I hope I'm in the right place, thanks!</p>
  
  <p>edit: I'm not even sure if this is possible to do in SQL, which is why I'm asking. </p>