How to Get Row Count Depending on Column Values using MySQL

Question

I am querying a mysql table and want results group by date, and one column name is type. There are two value for the type call and email. I want to find count for call and email for each day.

Find the SQL Fiddle here

I am trying with this query. Which only gets me total counts:

SELECT Date(date) date,
COUNT(type) total,
COUNT(type='email') emails,
COUNT(type='call') calls

from leads 
where user_id = 1 
GROUP BY Date(date)

fancyPants · Accepted Answer · 2014-02-10 12:07:06Z

1

Use SUM() instead. The type='email' in the function returns either 0 (false) or 1 (true).

SELECT Date(date) date,
COUNT(type) total,
SUM(type='email') emails,
SUM(type='call') calls
from leads 
where user_id = 1 
GROUP BY Date(date)

answered Feb 10, 2014 at 12:07

fancyPants

52.1k34 gold badges94 silver badges100 bronze badges

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

Collectives™ on Stack Overflow

How to Get Row Count Depending on Column Values using MySQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related