I tried to insert this query:
SELECT COUNT(DATE_FORMAT(dat,'%M')), DATE_FORMAT(dat,'%M') FROM table GROUP
BY DATE_FORMAT(dat,'%M') order by dat
but I`m not sure of proper result.
Regards,
Pawel
- Original Message -
From: "Pawel Filutowski" &
| 031214
2 | hub | 031215
3 | hub | 031217
4 | hub | 031218
- Original Message -
From: "Jay Blanchard" <[EMAIL PROTECTED]>
To: "Pawel Filutowski" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, December 15, 2003 1:53 PM
S
Thanks for Joshua and Jay.
The querys is that I expect.
Best regards,
Pawel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
I have table like this:
id | product
0 | switch
1 | switch
2 | hub
3 | hub
4 | hub
5 | wire
6 | wire
7 | wire
8 | wire
9 | wire
.
.
I`m looking for query which give me result as array:
0 - > count of 'switch'
1 - > count of 'hub'
2 - > count of 'wire'
Haw to do it ??
Regard
