I have two date fields. need to pull the data based on this two date fields and display it on monthly order (in words) like JAN , FEB… in Mysql
As of now my query is
SELECT `firstname` , `gender` , MONTH( `dol` ) AS 'month' FROM `student_details` WHERE `doa` = '2015-03-01' AND `dol` = '2015-06-17'
but this query is not working
i need it to display the records based on the months in words