title: SQL SELECT only field where it contains words
body: <p>I'm interested in doing something <a href="https://stackoverflow.com/questions/14290857/sql-select-where-field-contains-words">like in this question</a>, where I only get the result, if the column actually contains all the words given to it.</p>
  
  <p>For example, if I have two columns, one being a timestamp, the other being the weather, I want to get only the timestamps where the weather was <code>cloudy</code>, <code>rainy</code>, <code>snowy</code>, and not if it was only <code>cloudy</code>, <code>rainy</code>. An example of the above would be sort of like:</p>
  
  <pre><code>SELECT distinct timestamp FROM mytable
  WHERE Weather LIKE 'snowy'
     OR Weather LIKE 'cloudy'
     OR Weather LIKE 'rainy'
  </code></pre>
  
  <p>Which would return something like:</p>
  
  <pre><code>2017-09-22 snowy
  2017-09-22 snowy
  2017-09-22 cloudy
  2017-09-22 rainy
  2017-09-22 cloudy
  </code></pre>
  
  <p>But not any results <code>from 2017-09-21</code>, because it might only have been <code>snowy</code> and <code>rainy</code> that day etc.</p>
  
  <p>The example query I did above would return all timestamps, as long as the weather matched the criteria.</p>