Using DISTINCT and COUNT together in a MySQL Query

Question

Is something like this possible:

SELECT DISTINCT COUNT(productId) WHERE keyword='$keyword'

What I want is to get the number of unique product Ids which are associated with a keyword. The same product may be associated twice with a keyword, or more, but i would like only 1 time to be counted per product ID

Answer 1

You were close :-)

select count(distinct productId) where keyword='$keyword'

Answer 2

use

SELECT COUNT(DISTINCT productId) WHERE keyword='$keyword'

Answer 3

Isn't it better with a group by? Something like:

SELECT COUNT(*) FROM t1 GROUP BY keywork;

Answer 4

I would do something like this:

Select count(*), productid from products where keyword = '$keyword' group by productid

that will give you a list like
count(*) productid
5 12345
3 93884
9 93493

This allows you to see how many of each distinct productid ID is associated with the keyword