mysql select non unique rows code example

Example: mysql unique select count

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