Avoid the count of NULL values in mysql statement

Question

Want to only count the rows that are set and avoid the rows that are not set

SELECT COUNT(DISTINCT member_id) AS total_memebers, 
  COUNT(case member_feesdue when null then 1 else 0 end) AS total_feesdue 
FROM sdg_members

Dylan Su · Accepted Answer · 2016-02-17 16:45:54Z

2

COUNT never counts NULLs. SELECT COUNT(col) FROM tbl is enough.

answered Feb 17, 2016 at 16:45

Dylan Su

6,0751 gold badge18 silver badges26 bronze badges

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

Comments

Ikhlak S. · Accepted Answer · 2016-02-18 06:25:15Z

0

I think you are trying to count total_feesdue where it equals to 1?

SELECT COUNT(DISTINCT member_id) AS total_memebers, 
  (SELECT COUNT(*) FROM sdg_members WHERE sdg_members = 1) AS total_feesdue 
FROM sdg_members

answered Feb 17, 2016 at 17:38

Ikhlak S.

9,10411 gold badges60 silver badges80 bronze badges

I want to count only those rows from the column which has values and avoid the rows in which this column is empty