从日期字段中选择特定数据

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)

You can set your date range from the beginning and end of that month.

SELECT *
    FROM attendance
    WHERE `date` BETWEEN '2015-09-01' AND '2015-09-30'

You can use year and month function:

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

Try to use DATE_FORMAT. Your query is:

SELECT * FROM attendance WHERE DATE_FORMAT(date,'%Y-%m') = '2016-05'