title: Getting filtered data with multiple data sets as filters in MySQL
body: <p>I'm trying to build a filter to filter down users with multiple parameters. I realize that the query below is for post meta, but it works the same, and is easier to test on my side.</p>
  
  <pre><code>SELECT * 
  FROM wp_postmeta 
  WHERE (meta_key="_regular_price" AND meta_value="295") 
  AND (meta_key="_weight" AND meta_value="2.5")
  </code></pre>
  
  <p>When I do the above code I get no results, but if I change the AND between the 2 sets of brackets to OR it returns both results and from that I can see that there is at least 1 result (post_id) that is in both.</p>
  
  <p>What am I doing wrong here?</p>