sql - 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

use

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