title: How to find a range from two columns in mysql
body: <p>I have a value say 45.</p>
  
  <p>I want to check whether this value is present in database or not.</p>
  
  <p>The problem is that I have two columns, say:</p>
  
  <pre><code>--------------------
  range_from  range_to
  --------------------
     10 ------------ 20
  --------------------
     21 ------------ 30
  --------------------
     31 ------------ 40
  --------------------
     41 ------------ 50
  --------------------
  </code></pre>
  
  <p>How can I find this value? </p>
  
  <pre><code>SELECT * FROM Score WHERE range_from='' AND range_to=''
  </code></pre>