title: MySQL: JOIN two tables on LIKE
body: <p>I have a table with a column containing text, and I want to select all of the tables where the text from one of the rows in a second table appears in that row. Here is a pseudo-query:</p>
  
  <pre><code>SELECT title FROM recipes AS r 
     JOIN ingredients AS i 
     ON r.ingredients LIKE '%' + i.name + '%';
  </code></pre>
  
  <p>The above query does not work, however. How do I do this correctly?</p>