mysql Count of names using same number

Question

My Mysql table look like this

Field A         Field B
Red             yes
Blue                yes
Red             no
Green           no
Blue                yes
Blue                yes
Green           no
Green           yes
Red             no

I want the result to be:

Red     1
Blue        3
Green   1

Any help

Possible duplicate of Count distinct values

a spaghetto
– a spaghetto

2018-01-20 04:58:36 +00:00
Commented Jan 20, 2018 at 4:58 — a spaghetto
– a spaghetto, Commented Jan 20, 2018 at 4:58

feiiiiii · Accepted Answer · 2018-01-20 05:11:10Z

1

SELECT FieldA, count(FieldA)
FROM table
WHERE table.FieldB = "yes"
GROUP BY FieldA

answered Jan 20, 2018 at 5:11

feiiiiii

1,6031 gold badge15 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Juan Carlos Oropeza · Accepted Answer · 2018-01-20 05:04:44Z

0

conditional count

SELECT FieldA, COUNT( CASE WHEN FieldB = 'Yes' THEN 1 END)
FROM YourTable
GROUP BY FieldA

answered Jan 20, 2018 at 5:04

Juan Carlos Oropeza

48.4k14 gold badges87 silver badges128 bronze badges

Collectives™ on Stack Overflow

mysql Count of names using same number

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related