title: Do any know how get range data in between?
body: <p>I want to get the data in between two variables by getting it I will get estimate data in the table</p>
  <pre><code>select rate 
  from tbl_reporate 
  where purity='IF' 
    AND color='G' 
    AND weight_from &gt;= '1.78' 
    AND '1.78' &lt;= weight_to 
    AND shap='ROUND'
  </code></pre>
  <p>I am getting multiple data and not correct</p>
  <pre><code>13500
  27500
  35500
  46500
  74500
  </code></pre>