MySQL to get previous year record
<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>