O
O
Optimus2016-05-26 08:11:39
MySQL
Optimus, 2016-05-26 08:11:39

How to calculate count separately?

In table table column amimals there are 3 rows with value dog and 3 rows with value cat but the query is:

SELECT COUNT(*) FROM `table` WHERE uid='1' AND animals IN ( 'cat','dog' )

Shows one digit with a value of 6. Can I somehow remake it to display 3 and 3?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Anton B, 2016-05-26
Pyan @marrk2

Add GROUP BY animals to the end of the query

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question