title: Get records in date ranges
body: <p>I need the records between two date ranges</p>
  
  <p>I have below records in mysql table</p>
  
  <pre><code>**id  start_date  End_date**
  1   2016-04-11  2016-04-18
  2   2016-04-19  2016-04-19
  3   2016-04-20  2016-04-21
  4   2016-04-22  2016-04-29
  5   2016-05-01  2016-05-01
  6   2016-05-08  2016-05-10
  </code></pre>
  
  <p>I will provide input as 
  2016-04-18 and 2016-04-24</p>
  
  <p>My input values does not points to start and end date. It points to range of dates.My output should contain records with data range from (2016-04-18 to 2016-04-24,both start and end date)</p>
  
  <p>It should provide the output as below</p>
  
  <pre><code>**id  start_date  End_date**
  1   2016-04-11  2016-04-18
  2   2016-04-19  2016-04-19
  3   2016-04-20  2016-04-21
  4   2016-04-22  2016-04-29
  </code></pre>
  
  <p>First record is &lt;= 2016-04-18 So I need this</p>
  
  <p>Second record is &lt; 2016-04-24 So I need this</p>
  
  <p>Third record is &lt; 2016-04-24 So I need this</p>
  
  <p>Fourth record is &lt;2016-04-24 So I need this</p>