mysql select count of unique values code example

Example: mysql unique select count

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