CodesJava

Easy learning with example program codes

OR condition in MySQL

MySQL OR
In MySQL, the OR 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
OR condition_2
OR condition_3
….
OR 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 = 2
OR id = 4;

Output:

ID	NAME	   QUANTITY
2	Sports	   45
4	Grocery	   90
2 rows  in set <0.01 sec>
Please follow and like us:
error









Copyright © 2019 CodesJava DMCA.com Protection Status