title: Filtering data using multiple AND operators in mysql
body: <p>I have a table named skills :</p>
  <p><a href="https://i.stack.imgur.com/aMQQK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/aMQQK.png" alt="screen shot for skills table" /></a></p>
  <p>I want to search for users having skill java with 2+ year experience and also having skill jquery with 1+ year experience.</p>
  <p>I tried this :</p>
  <pre><code>SELECT `userid` FROM `skills`
  WHERE `skill` =   'java' AND `experience` &gt; 2
    AND `skill` = 'jquery' AND `experience` &gt; 1
  </code></pre>
  <p>The expected result is 15. but the query returned an empty result set.</p>
  <p>Any help will be appreciated. Thanks in advance!</p>
  <hr />
  <h3>Note:</h3>
  <p>The number of conditions in where clause may vary.</p>