How do I count the number of records in a MySQL query?

1.	How do I count the number of records in a MySQL query?
Answer» SELECT COUNT(*) from TABLE_NAME where 'status' = 1;

Discussion