title: How do I find the row where a certain value is between 2 others?
body: <p>So, I have a mysql table that looks roughly like this, where the first 2 columns contain ranges.</p>
  
  <pre><code>1 , 5  , Value1
  6 , 14 , Value2
  14 , 18 , Value3
  </code></pre>
  
  <p>How can I query to find which row a certain value falls between (ie, if I have 9, it returns Value2; if I have 2, it returns Value1). This table is about 10mb big, so the more efficient, the better.</p>
  
  <p>Thanks!</p>