title: check if column contains one of many values
body: <p>i have an array of strings and a column which may contain one or more of those strings(seperated by space) i want to get all rows where this column contains one of the strings. Since the values all have 3 letters and therefore can't contain each other, i know i could just write </p>
  
  <pre><code>SELECT * FROM table WHERE 
  column LIKE '%val1%' OR 
  column LIKE '%val2%' OR 
  column LIKE '%val3%' OR 
  column LIKE '%val4%'
  </code></pre>
  
  <p>But i'm wondering if there isn't an easier statement, like <code>column IN ('val1', 'val2', 'val3', 'val4')</code> (This one seems only to work when the entry is equal to one of the values, but not if it just contains them)</p>