To search by date in MariaDB, you can use the WHERE clause in your SELECT statement and use comparison operators (like =, >, <, !=, BETWEEN, etc.) to specify the date or date range you want to search.
Here’s a basic example:
```
SELECT *
FROM your_table
WHERE your_date_column = ’2022-01-01’;
```
If you’re dealing with a DATETIME or TIMESTAMP column and you want to filter based on the date portion only, you can use the DATE function:
```
SELECT *
FROM your_table
WHERE DATE = ’2022-01-01’;
```
If you want to search between two dates you can use the BETWEEN operator:
```
SELECT *
FROM your_table
WHERE your_date_column BETWEEN ’2022-01-01’ AND ’2022-12-31’;
```
Note that the date format is ‘YYYY-MM-DD’. It’s also worth mentioning that you should have an index on the date column(s) you’re filtering on in order to get good performance.
