how to do reduce multiple query into one query <pre><code>Query 1: select item_no from hdd where item_no='$in' and id != '$id' Query 2: select sr from hdd where sr='$hd' Query 3: select item_no from hdd where casing_no='$c' and id != '$id' </code></pre> <p>Result Required : </p> <pre><code>Q1 = num_rows = 0 Q2 = num_rows &lt;&gt; 0 Q3 = num_rows = 0 </code></pre> <p>How can perform above task in single query ? ?</p> <p>Done this :</p> <pre><code>SELECT id FROM hdd WHERE status='1' AND item_no='$in' AND FIND_IN_SET('$hd', sr)&lt;&gt;0 AND casing='$c' AND id&lt;&gt;'111' </code></pre>