Get meta value by using meta key from mysql
<p>I am working with wordpress. I am going to make custom filter. In which I want  memberId using metakey. </p>

<p>My table structure like below table.<br>
<a href="https://i.stack.imgur.com/QqF81.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QqF81.png" alt="enter image description here"></a></p>

<p>Reference Question: <a href="https://stackoverflow.com/questions/21326557/php-get-meta-value-by-using-meta-key-from-mysql">php - get meta value by using meta key from mysql</a>  </p>

<p>My Final statement is below: </p>

<pre><code>select distinct(memberid) from membermetas 
where memberMeta = 'kilo' 
and memberMetaValue &gt;= 90 
and memberMeta = 'boy' 
and memberMetaValue &lt;= 175
</code></pre>

<p>When I am trying to write this query I got nothing.</p>

<h3>How to write query for getting memberId for 2 or 3 condition on memberMeta field?</h3>