And condition in MySQL

MySQL AND
In MySQL, the AND condition is used to filter the results obtained through the SELECT, INSERT, UPDATE and DELETE statements based on more than one conditions.

Syntax:

WHERE condition_1
AND condition_2
AND condition_3
….
AND condition_n; 

Parameters:
condition_1, condition_2… condition_n: They are used to specify the conditions to be strictly followed for selection.

Example:
Items table:

ID NAME QUANTITY
1 Electronics 30
2 Sports 45
3 Fashion 100
4 Grocery 90
5 Toys 50

Query:

SELECT *  
FROM items  
WHERE  id < 4 AND id > 1;

Output:

ID NAME QUANTITY
2 Sports 45
3 Fashion 100
Please Share