Re: COUNT() query help

[Richard Quadling <rquadling@xxxxxxxxx>]

On 13 August 2010 13:43, Ron Piggott <ron.piggott@xxxxxxxxxxxxxxxxxx> 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
> `bible_concordance_word_reference` ON
> `bible_concordance_words`.`reference` =
> `bible_concordance_word_reference`.`bible_concordance_words_reference`
> WHERE `word` LIKE '$letter%' ORDER BY `word` ASC

SELECT
	`bible_concordance_words`.`word`,
	COUNT(`bible_concordance_word_reference`.`bible_concordance_words_reference`)
AS occurrences
FROM
	`bible_concordance_words`
	INNER JOIN
	`bible_concordance_word_reference` ON
		`bible_concordance_words`.`reference` =
`bible_concordance_word_reference`.`bible_concordance_words_reference`
WHERE
	`word` LIKE '$letter%'
GROUP BY
	`bible_concordance_words`.`word`,
ORDER BY
	`word` ASC

-- 
Richard Quadling.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php