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)
SELECT * FROM attendance WHERE date = (year-month)
You can set your date range from the beginning and end of that month.
WHERE `date` BETWEEN '2015-09-01' AND '2015-09-30'