Suc> COUNT() only counts non-null values. Suc> More on topic...if you say COUNT(fieldname), you say that you want to Suc> count all of the non-null values in that column.
COUNT(1) or COUNT(2) or COUNT(any_constant) should count all records (this is how it works for example in oracle) -- Best regards, DebugasRu mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]