title: MySQL - Match reference table against concatenated string
body: <p>I have problems achieving the following:</p>
  
  <ul>
  <li>I have a "reference table" consisting only of strings</li>
  <li>I have a "data table" which does have a field containing a string which is concatenated from several strings which can occur in the reference table. The syntax which delimits the strings varies - so they cannot be splitted easily.</li>
  </ul>
  
  <p>What I need is a query which runs through the reference table and searches if the data table has rows where this concatenated string contains values from the reference table.</p>
  
  <p>Also it would be perfect if the query would return the PK of the data row as well as the string(s) which were found from the reference table.</p>