SELECT LEFT(DATE_FIELD_NAME, 10), COLOR_FIELD_NAME, COUNT(T.*) AS CNT FROM
TABLE_NAME GROUP BY LEFT(DATE_FIELD_NAME, 10), COLOR_FIELD_NAME.
Post the table structure if this does not help.
On 10/27/07, Neil Tompkins <neildtompkins@stripped> wrote:
> I have a table of records all of which have a timestamp against them like
> 2007-10-25 10:10:19, and category like red, blue etc and a unique key.
> Using a SELECT statement is it possible to retrieve the count and number
> of records for each day e.g 2007-10-25 for all red, and all blue etc
> Feel like a local wherever you go.