COUNT(*) vs COUNT(id) in MySQL
“TL;DR: Use COUNT(), not COUNT(id), when you want to count rows. You have probably read in a bunch of different places that you shouldn’t use SELECT() in MySQL when you don’t need all the data. SELECT(*) selects all the columns in the table, not just the ones that you might need.”
read »