According to mysql docs count(expr) is the count o...

# exposed

[spand]

According to mysql docs count(expr) is the count of rows with non-null expr where as count(*) always includes row