On 13 August 2010 13:43, Ron Piggott ron.pigg...@actsministries.org wrote:
SELECT `bible_concordance_words`.`reference`,
`bible_concordance_words`.`word`,
COUNT(`bible_concordance_word_reference`.`bible_concordance_words_reference`)
AS occurrences FROM `bible_concordance_words` INNER JOIN
Barry,
Is it posible to do a count(*) on a tabe where id=2 and count just those that id = 2
=why don't you try it?
The answer is yes, because count(*) means count the entire number of non-null rows
selected.
See manual: 3.3.4.8 Counting Rows
=dn
--
PHP Database Mailing List
Hi,
SELECT SUM(IF(id = '2',1,0)) AS field_name FROM table
Versatile command - you can use it for quite a lot of things.
Barry Rumsey wrote:
Is it posible to do a count(*) on a tabe where id=2 and count just those that id =
2
--
--
Dan Barton
Terrestrial Program Biologist
Asst.