How can you count the number of elements given a condition?

Question

PHP

Good afternoon!
The essence of the question is this.
How can you calculate the number of elements under this condition.
There is a group or, as it is correct, an array of values:
Parameter 1
- Blue
- White
- Red
How can you calculate the number of each parameter in the table, provided that it is valid id = 5.
Maybe I didn’t write it correctly, but I think the essence is clear.

Answer 1

Not quite clear.
allows you to count the number of occurrences by parameters.
if you add where, then you can still filter
that in your case the condition is not clear

Answer 2

MySQL IF Function ?