|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
November 30th, 1999, 07:54 PM
|
|||
|
|||
|
I want to get the following result on a webpage :
Date Name type1 type2 type3 1999/11/10 joe 10 2 6 But my in my table they are stored like this : 1999/11/10 joe type1 1999/11/10 joe type2 1999/11/10 joe type1 1999/11/10 joe type3 1999/11/10 joe type1 Can anyone help me with the right query? I know in MS Access you can do this with : count(IIF(type=type1),1,0) Is there a function like this for MySQL?
|
|
#2
December 3rd, 1999, 07:55 PM
|
|||
|
|||
|
I found it myself (finally)
The way to go is : Select date,count(IF(type='Normal',1,0)).. . group by date; Thanks!
|
|
| Viewing: Dev Shed Forums > Databases > MySQL Help > Special Count |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
