title: To get records in between two date in mysql
body: <p>See the below table,
  In this date column type is varchar not date.</p>
  
  <pre><code>           |---------------------|
             |date       |   name  |
             |---------------------|
             |23-5-2005  | babi    |
             |20-6-2005  | ram     |
             |12-5-2005  | jhon    |
             |1-5-2004   | babi    |
             |23-5-2005  | guru    |
  </code></pre>
  
  <p>Know I want to get records between two dates.</p>
  
  <pre><code>String gt = "12-5-2005";
  String gt1 = "20-6-2005";
  String query = ??;
  </code></pre>
  
  <p>How can I write the query to get names between strings gt and gt1</p>