Months in Mysql

[Mr Chris]

Hi All,

 

I have a query which outputs a count of months

 

SELECT MONTH(published) as the_month, COUNT(*) AS total FROM cfm_stories 
WHERE YEAR(published) = YEAR(NOW())
GROUP BY MONTH(published)
LIMIT 1,6

 

But how do I force a column to be created with the month name.  IE at the moment Febuary's value for the_month is 2, March is 3 etc...

 

Thanks

[PFMaBiSmAd]

See the mysql DATE_FORMAT() function. A %M format parameter would give the month name.

[Barand]

as will

 

SELECT MONTHNAME(published)