Search all records for a respective year and month

Question

In my BD I have the date field of type date (YYYY-mm-dd). What happens is I want to fetch all the records for a given year and month. For example, I want to get all the records for 2014 of the month 08. How can I do that? I tried something like this:

SELECT * FROM tbl_ocorrencias WHERE `data` = '2014-08-d' 

Answer 1

SELECT * FROM tbl_ocorrencias
WHERE
   YEAR( data ) = 2014 AND MONTH( data ) = 8