how to query this ??

[PHPycho]

Hello forums !!
I would like to know how to count the no of fields that has specific values.
for example:

"table1" has field called "filed1" and it has values

|field1|

|X |
|X |
|Y |
| X |
:
:
etc
I would like to know the no of rows that has the value X using count...
How to perform such query..
thanks in advance to all of you

[Roger_Ramjet]

You do that with GROUP BY and the Aggregate Functions

[nemonoman]

Hint: You query will look something like "
SELECT COUNT(*)
FROM table1
WHERE filed1='X'

Buy what would happen if you said:
SELECT filed1, COUNT(*)
FROM table1
GROUP BY 1
???
That's when things would get interesting indeed. Read R Ramjet's link to find out.