title: Mysql date range does not return correct range
body: <p>Here is my code:</p>
  
  <pre><code>select date_format(fee_month, '%b-%Y') from bb_fee_info where 
  date_format(`FEE_MONTH`,'%b-%Y') &gt;= 'Apr-2016' 
  and date_format(`fee_month`, '%b-%Y') &lt;= 'Apr-2017'
  </code></pre>
  
  <p>As per my understanding above statement should return from April-2016 to April-2017 but it only returns <code>April-2017</code> records why is that ?</p>
  
  <p>FYI in my Table <code>fee_month</code> stored as <code>date</code> data type and for example, for April month records all my <code>fee_month</code> will be stored as <code>2017-04-01</code>.</p>