How to use the group function

[Anon]

I have a table with 2 field, named "a" & "b"

"b" is a date field contain day, month & year.

Now I want to use a group function group by the month of the field "b" in order to group with the different month, may anyone tell me how to do this??

[Anon]

what DB u r using ???

[Anon]

I'm using mysql, thk!!

[Anon]

If ur date is in yyyy-mm-dd format,following query should work,

select substring(date,6,2),count(*) from table group by 1;