title: How to select records b/w two month names in MYSQL
body: <p>I am very much new to MYSQL,so i had written something like this.</p>
  
  <p>modified_date is in month like for ex:2017-03-24 13:38:11</p>
  
  <pre><code>select * from TableName  
  where  monthname(modified_date) between  monthname(a.modified_date)= "March" 
  and monthname(modified_date)="June" ;
  </code></pre>
  
  <p>For the above query i am getting an error(Please refer the pic)
  <a href="https://i.stack.imgur.com/t0z6a.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/t0z6a.png" alt="enter image description here"></a>.</p>