Using DISTINCT and COUNT together in a MySQL Query December 8, 2022 by Tarik use SELECT COUNT(DISTINCT productId) from table_name WHERE keyword='$keyword'