Mysql query count issue including blank strings

Question

Hello i am trying to count tracking numbers with non null non empty string in mysql

i see that count won't include null values. But is there a way to make it not include '' empty strings as well?

Thank you.

-Brendon

Noam Rathaus · Accepted Answer · 2013-11-25 20:23:33Z

2

Try this, it will skip both NULL (which count doesn't count anyway) as well as empty string:

SELECT COUNT(*)
FROM TABLE
WHERE column_name != '' and column_name IS NOT NULL

answered Nov 25, 2013 at 20:23

Noam Rathaus

5,6082 gold badges31 silver badges37 bronze badges

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

3 Comments

Tin Tran Over a year ago

mysql seems to count NULLs as well unless you specify COUNT(column_name) but yeah this query looks right!

Noam Rathaus Over a year ago

COUNT() counts rows returned, so it should count if no rows return, so if you remove COUNT() and just call the query with * you should see how many rows return, this is the COUNT() result.

Tin Tran Over a year ago

I also thought you needed a TRIM(column_name) just in case when column_name is ' ' but apparently, you don't.

Collectives™ on Stack Overflow

Mysql query count issue including blank strings

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related