OR condition in MySQL

MySQL OR
In MySQL, the OR condition filters the results obtained through the SELECT, INSERT, UPDATE, and DELETE statements based on multiple conditions.

Syntax:

WHERE condition_1
OR condition_2
OR condition_3
….
OR condition_n;

Parameters:

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

Example: Items table:

Query:

SELECT *
FROM items
WHERE id = 2
OR id = 4;

Output: