Count using data from two columns

Question

I have a progress column and an email date column. I'd like to have count 3 results as variables:

First: Progress = 0
Second: Progress = 1, EmailDate == 0000-00-00 00:00:00
Third: Progress = 1, EmailDate !== 0000-00-00 00:00:00

Currently I have the following:

SELECT Progress, COUNT(*) AS counter
FROM myTable
GROUP BY Progress

However, it isn't using the Email Date, when I try and use it, I get a zero value.

This is this related to PHP? This is just a MySQL problem. – OptimusCrime Sep 14 '17 at 14:03 — OptimusCrime, Sep 14 '17 at 14:03

score 1 · Accepted Answer · answered Sep 14 '17 at 14:06

1

SELECT
    SUM(IF(progress = 0,1,0)) AS Counter_1,
    SUM(IF(progress = 1 AND EmailDate = '0000-00-00 00:00:00',1,0)) AS Counter_2,
    SUM(IF(progress = 1 AND EmailDate != '0000-00-00 00:00:00',1,0)) AS Counter_3
FROM myTable

answered Sep 14 '17 at 14:06

matks

96
7

Count using data from two columns

1 Answers1