title: Equivalent of "IN" that uses AND instead of OR logic?
body: <p>I know I'm breaking some rules here with dynamic SQL but I still need to ask.  I've inherited a table that contains a series of tags for each ticket that I need to pull records from.  </p>
  
  <p>Simple example...  I have an array that contains "'Apples','Oranges','Grapes'" and I am trying to retrieve all records that contain <strong>ALL</strong> items contained within the array.</p>
  
  <p>My SQL looks like this:</p>
  
  <pre><code> SELECT * FROM table WHERE basket IN ( " + fruitArray + " )
  </code></pre>
  
  <p>Which of course would be the equivalent of:</p>
  
  <pre><code> SELECT * FROM table WHERE basket = 'Apples' OR basket = 'Oranges' OR basket = 'Grapes'
  </code></pre>
  
  <p>I'm curious if there is a function that works the same as IN ( array ) except that it uses AND instead of OR so that I can obtain the same results as:</p>
  
  <pre><code> SELECT * FROM table WHERE basket LIKE '%Apples%' AND basket LIKE '%Oranges%' AND basket LIKE '%Grapes%'
  </code></pre>
  
  <p>I could probably just generate the entire string manually, but would like a more elegant solution if at all possible.  Any help would be appreciated.</p>