title: Partial matching with Oracle
body: <p>I have the following records</p>
  
  <p>Master String</p>
  
  <pre><code>abc,def,ghi,jkl,mno
  </code></pre>
  
  <p>Records    </p>
  
  <pre><code>abc,ghi,xyz
  bbb,jkl
  abc,ghi,mno
  bbb,ggg
  </code></pre>
  
  <p>Each of these records are concatenated fields from another query. (the first record is a concatenation of "abc", "ghi" and "xyz").</p>
  
  <p>From the above, I'm supposed to confirm if the fields in the strings contain a match to the master string.  In this scenario, the first three records are matching because they each have at least one field that matches the master string.</p>
  
  <p>Is there any way to use a single query to handle this? The only way I can think off is to break each records into its components and matching it individually, but I am hoping for a more efficient solution. I can't seem to get regex to work with this either. </p>