IN and BETWEEN are widely used in SQL and their usage is the same in MariaDB.
The IN operator allows you to specify multiple values in a WHERE clause. It is a shorthand for multiple OR conditions. Here is an example of how to use IN Operator in MariaDB:
```
SELECT *
FROM employees
WHERE employee_id IN (1,2,3);
```
The query will return all details for the employees whose IDs are 1, 2, or 3.
BETWEEN operator is used to filter the result set within a certain range. The values can be numbers, text, or dates. Here is an example of how to use BETWEEN Operator in MariaDB:
```
SELECT *
FROM orders
WHERE order_date BETWEEN ’2019-01-01’ AND ’2019-12-31’;
```
The query will return all orders made in the year 2019.
Also, you should note that the BETWEEN operator is inclusive — that is, the end values are included in the range. If you want an exclusive range, you should use a combination of greater-than (>) and less-than (<) conditions.
