Need to show the data from two date fields based on months in Mysql?

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


Source: syntax

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.