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

Accepted Answer

use

```
SELECT COUNT(DISTINCT productId) from  table_name WHERE keyword='$keyword'
```

Using DISTINCT and COUNT together in a MySQL Query

Solution

Problem