MySQL COUNT() fuction
MySQL count() function is used to return the count of an expression. It is used when you need to count some records of your table.
syntax
SELECT COUNT (aggregate_expression) FROM table_name [WHERE conditions];
SELECT COUNT (aggregate_expression) FROM table_name [WHERE conditions];