title: SQL Find & return matched keywords from list
body: <p><strong>Scenario</strong></p>
  
  <p>Say I have a <code>comments</code> table like</p>
  
  <pre><code>comment_id | comment
  1          | a quick fox jumped over the lazy dog 
  2          | a lazy bull slept in the chicken den
  </code></pre>
  
  <p>and I have a <code>keywords</code> table like this</p>
  
  <pre><code>animal_id  | keyword
  1          | bull
  2          | chicken
  3          | dog
  4          | fox
  </code></pre>
  
  <p><strong>Question</strong></p>
  
  <ol>
  <li><p>Is it possible to do a search comment for the keywords shown? something like <code>instr(comments.comment, keywords.keyword)</code>?</p></li>
  <li><p>Is it possible to return the matched keywords from the table like</p></li>
  </ol>
  
  <pre><code>comment_id | animal_id
  1          | 3
  1          | 4
  2          | 1
  2          | 2
  </code></pre>