title: MySQL to get previous year record
body: <p>I want a MySQL query to fetch previous year records. 
  I already wrote a query to fetch current year records but I want previous year record also. There is a column called "date_created" based upon this date I have to fetch the status of the meterial.</p>
  
  <pre><code>SELECT material_status, COUNT(*) c
  FROM purchase_order
  WHERE YEAR(date_created) = YEAR(CURDATE()) AND material_status='open'; 
  </code></pre>