MySQL group by empty and non-empty values

Question

At present, I have something like:

select sum(total) from table_name where field != ''
UNION
select sum(total) from table_name where field = ''

It works but I'm curious if it is possible to use "group by" to filter by empty and non-empty values?

Sagar Gangwal · Accepted Answer · 2017-08-24 05:04:20Z

1

select SUM(CASE WHEN field != '' THEN total ELSE 0) NONEMPTY,
       SUM(CASE WHEN field = '' THEN total ELSE 0) EMPTY from table_name

Try above query.

Here i had used CASE WHEN.

answered Aug 24, 2017 at 5:04

Sagar Gangwal

8,1303 gold badges28 silver badges45 bronze badges

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

3 Comments

I cannot see GROUP BY here

Well, the question is very specific

Yes, you're not answering the question