title: How to SELECT using both wildcards (LIKE) and array (IN)?
body: <p>In SQL, if you want to perform a SELECT with a wildcard, you'd use:</p>
  
  <pre><code>SELECT * FROM table_name WHERE field_name LIKE '%value%'
  </code></pre>
  
  <p>If you wanted to use an array of possible values, you'd use:</p>
  
  <pre><code>SELECT * FROM table_name WHERE field_name IN ('one', 'two', 'three')
  </code></pre>
  
  <p>But, what would you do if you wanted to use both wildcards AND an array?</p>
  
  <p>Kind of like:</p>
  
  <pre><code>SELECT * FROM table_name WHERE field_name LIKE IN ('%one', '_two', 'three[abv]')
  </code></pre>