title: Comparison of multiselect picklist with a field in text format in apex
body: <p>I have an object with number of records in this format with Name in Text format - </p>
  
  <pre><code>Id  Name
   1  A,B,C
   2  A,B
   3  A
   4  B
   5  A,C
   6  A,D
  </code></pre>
  
  <p>I have a multi-select picklist with values as:</p>
  
  <pre><code>A
  B
  C
  D
  </code></pre>
  
  <p>So if I select B and C in my picklist, then I must have the records from the table in which name consists of B or C or (B and C) i.e. in this case, it should show 4 records: </p>
  
  <pre><code>1 A,B,C
  2 A,B
  4 B
  5 A,C
  </code></pre>
  
  <p>I am using SQL query with IN and INCLUDES keyword but I am unable to achieve this functionality.</p>