title: Imitate array_intersect in MySQL
body: <p>I have a table like this:</p>
  
  <pre><code>Col1    Col2
  word1   872
  word1   333
  word2   631
  word3   982
  word3   111
  word4   111
  word5   631
  word6   333
  word6   453
  </code></pre>
  
  <p>I would like to receive the results of multiple SELECTs, but only those results which occur in all results. For example, if I am searching for <code>SELECT col2 FROM table WHERE col1='word1'</code> and <code>SELECT col2 FROM table WHERE col1='word6'</code>, I want to join these two statements together to have a single MySQL statement which will return only the results that occur in both of the above example queries. (The same as array_intersect works in PHP.)</p>
  
  <p>I need a single query that will do this for any number of col1 words.</p>
  
  <p>Sorry, if I haven't explained very well. It was difficult to explain.</p>