Select specific data from date field

Question

I am trying to get some record from table for specific month and year and I have only complete date field.

In the above image I want to select the data from date but only for (2015-09)

E.g.:

SELECT * FROM attendance WHERE date = (year-month)

Answer 1

You can use year and month function:

SELECT * FROM attendance WHERE year(`date`) = '2015' and month(`date`) = '9'