Finding All Months

[Anon]

Is there any way to query a MySQL database to return all of the unique months that it has in a specified table. I would like it to search through records with every day of the year, but only return 01, 02, 03, etc... for all of those that it finds with a unique month.

[Anon]

run your query using distinct?

I'm not clear on your question. You can run a query such at

"Select distinct months from table";

that will return a list of all the months in there. so if you have data for january 1-21, march 1-18 and december 8-24. It will return:

January, March, December

[Anon]

That's exactly what I need.

Thanks