mysql show category once count how many products
snippet in sql

mysql show category once count how many products

user5854

SELECT category, COUNT(*) as count FROM table GROUP BY category