title: Syntaxes and IN(each) instead of IN(or) issues in MySQL
body: <p>i'm a begginer in databases. My issue is hard to explain with words since i'm not that good in english, so here is what i would do :</p>
  
  <pre><code>SELECT DISTINCT(link)
  FROM foo
  WHERE
  (
    foo.name IN('bar1' AND 'bar2')
  )
  AND
  (
    foo.text IN('bar3' AND 'bar4' AND ...)
  )
  AND
  (
    foo.desc = 'bar'
  )
  AND (...) etc..
  LIMIT 100
  </code></pre>
  
  <p>if found this solution seems working great but not in my case of multiple WHERE statements (when syntaxe doesn't allow to have groupby+having in each parentheses):</p>
  
  <pre><code>foo.name IN('bar1', 'bar2') // len = 2
  GROUP BY link
  HAVING COUNT(foo.name) = 2  // len
  </code></pre>
  
  <p>May be difficult to understand so here is an simple example of table :</p>
  
  <pre><code>| id | link | name |
  | -- | ---- | ---- |
  | 01 | HG.C | bar1 |
  | 02 | IJ.N | bar2 |
  | 03 | HG.C | bar2 |
  | 03 | SZ.W | bar3 |
  
  SELECT DISTINCT(link)
  FROM foo
  WHERE
  (
    foo.name IN('bar1' AND 'bar2')
  )
  </code></pre>
  
  <p>It should return : HG.C</p>
  
  <p>I tried many things that failed so i'm still looking for a way... i guess my brain isn't formatted (yet) for SQL. If somebody can help me, would be so nice.</p>