Hi!!
You can try
select format_date(field2, '%m %d %Y)as timestamp, count(*), field1 from mad
group by field1
all the best,
Jayasimhan A
- Original Message -
From: cristian ditoiu <[EMAIL PROTECTED]>
To: mysql <[EMAIL PROTECTED]>
Sent: Friday, March 22, 2002 1:20 PM
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
> sql,query
> If you just reply to this message, and include the entire text of it in the
> reply, your re
I have MySql database containing a table mad by several fields among wich :
Field1 (varchar) , Field 2 (timestamp) .
I want to do :
select count(*) , field1 , group by field1 .
That's ok , but i'd like to get results like :
2002-01-01 3
2002-01-02 4
.
How can i do that considering the timest
