Re: COUNT() query help
| From: | Richard Quadling | Date: | Fri, 13 Aug 2010 12:50:23 +0000 |
| Subject: | Re: COUNT() query help | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-47307@lists.php.net to get a copy of this message | ||
On 13 August 2010 13:43, Ron Piggott <ron.piggott@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
> 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.