title: MySQL query to fetch result between start date and end date
body: <p>I have two dates say <code>start_date = 2013-04-12</code> and <code>end_date =  2013-04-30</code><br>
   and my table contains row with <code>start_date = 2013-04-12</code> and <code>end_date = 2013-04-16</code></p>
  
  <p>I want to fetch records whose start date is greater 2013-04-12 and end_date is less than 2013-04-30. Which includes above record having 2013-04-16 as end_date</p>
  
  <p>I tried with this query </p>
  
  <p><code>SELECT * FROM TABLE_NAME WHERE (start_date &lt;='2013-04-12' AND end_date &gt;='2013-04-30')</code> which dont give any result however if i put end_date 2013-04-15 it works fine</p>