Page 1 of 1

How Many?

Posted: Sat Mar 06, 2004 4:48 pm
by NeoPuma
Hi,
How do I find how many things are in a certain colum.
e.g: How many H's are in colum Letter (in the MySQL).

Thanks
-Neo

Posted: Sun Mar 07, 2004 4:34 am
by microthick
You can use the MySQL COUNT() function.

So, to find out how many H's you have in the column Letter, you can go:
SELECT COUNT(*) As letterKount FROM Letter WHERE theLetter = 'H'