title: How to select the result between two numbers range?
body: <p>I need to select the result based on the column <code>col1</code> value.
  <code>col1,col2</code> is text field type.  </p>
  
  <pre><code> +-----+-----------+------+
   | id  |    col1   | col2 |
   +-----+-----------+------+
   | 1   | 1200-1220 | XXX  |
   +-----+-----------+------+
   | 2   | 1455-1460 | YYY  |
   +-----+-----------+------+
  </code></pre>
  
  <p>Example query:</p>
  
  <pre><code>SELECT col2 FROM TABLE_NAME WHERE col1 = 1215
  </code></pre>
  
  <p>Result i want:</p>
  
  <blockquote>
    <p>'XXX'</p>
  </blockquote>
  
  <p>How I get the above result.</p>
  
  <p>If I inserted wrong, in which format I need to insert a row to get the result.</p>
  
  <p>Please advise.</p>