Using DISTINCT and COUNT together in a MySQL Query

Question

Is something like this possible:

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

What I require right now is to get the number of unique product IDs connected with a keyword. The same product may be connected twice with a keyword, or more, however, I need only 1 time to be counted per product ID.

Answer 1

You can use the following code:

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

Want to become a SQL Expertise? Join the SQL Course and get certified.

For more details on MySQL, refer to the below MySQL Tutorial video.