title: MySQL query gives invalid results
body: <p>I have written a query for fetching details from my mysql table under some conditions.
  My table contains rows satisfying the query but it returns an empty result set.Can anyone tell me why this happening?</p>
  
  <p>Here is my query</p>
  
  <pre><code>select * 
  from product 
  where price&gt;='0' and price&lt;='1000' 
  and internal&gt;='0' and internal&lt;='32' 
  and screensize&gt;='1' and screensize&lt;='8' 
  and camerares&gt;='0' and camerares&lt;='20' 
  and p_brand like '%%%' and carrier like '%%%' 
  and color like '%%%' and operating like '%%%'
  </code></pre>