MySQL OR Operator: Examples

SELECT 1 = 1 OR 1 / 0;

SELECT true OR false AND false;

SELECT (true OR false) AND false;

SELECT 
    customername, country
FROM
    customers
WHERE
    country = 'USA' OR country = 'France';

SELECT 
    customername, country, creditLimit
FROM
    customers
WHERE
    (country = 'USA' OR country = 'France')
        AND creditlimit > 100000;

SELECT
    customername, country, creditLimit
FROM
    customers
WHERE
    country = 'USA' OR country = 'France' AND creditlimit > 100000;

SELECT * FROM customers;

SELECT * FROM employees;

SELECT * FROM offices;

SELECT * FROM orderdetails;

SELECT * FROM orders;

SELECT * FROM payments;

SELECT * FROM productlines;

SELECT * FROM products;