Nick Upson wrote:
Is there any time where there is an effective difference between:
select count(`*`) from ...
and:
select count(myfieldname) from ... ?
Helen Borrie answers:
Sure is. count(*) counts all rows, whereas count(fieldname) counts all rows that have a non-null value in that field.