mysql distinct count group by

count distinct 的字段

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

(Using DISTINCT and COUNT together in a MySQL Queryy)[https://stackoverflow.com/questions/1002349/using-distinct-and-count-together-in-a-mysql-query/17887836]