The MySQL OR condition specifies that if you take two or more conditions then one of the conditions must be fulfilled to get the records as result.
Syntax:
WHERE condition1 OR condition2 ... OR condition_n;
condition1, condition2, ... condition_n: Specifies all conditions that must be fulfilled for the records to be selected.
The following example specifies how to use the OR condition in MySQL with SELECT statement.
Consider a table "cus_tbl", having the following data:
Execute the following query:
SELECT * FROM cus_tbl WHERE cus_firstname = 'Ajeet' OR cus_id > 100;
Output:
Note: In the above example you can see that the second condition "cus_id" is wrong but the query is displaying the correct result because of the OR condition.
