The COUNT function in MariaDB is used to return the number of rows that matches a specified criteria.
Here is a basic example how to use it:
```
SELECT COUNT FROM table_name;
```
This will return the number of non-NULL values in the `column_name` column from the `table_name` table.
If you want to count the number of rows that match a specific condition, you would use it like this:
```
SELECT COUNT
FROM table_name
WHERE condition;
```
This will return the number of non-NULL values in the `column_name` from the `table_name` table where the `condition` is true.
If you want to count all rows in a table (including those with NULL), use `COUNT`:
```
SELECT COUNT
FROM table_name;
```
Note: All these queries are case sensitive in MariaDB. The column name, table name, and condition must be exactly as they are in the database.
