title: Financial Year in MySQL
body: <p>I need to select data of financial year</p>
  <p>I'm using the below query but not working</p>
  <pre><code>SELECT * FROM TABLE
  WHERE STR_TO_DATE(date_column ,'%Y-%m-%d') BETWEEN 
  CONCAT(YEAR(CURRENT_DATE)-1,'-04-01') AND CONCAT(YEAR(CURRENT_DATE),'-03-31')
  </code></pre>
  <p>can anyone help!</p>