MySQL AND Operator: Examples

Back Home

Examples
Sample Database

#1

SELECT 1 = 0 AND 1 / 0 ;

#2

SELECT customername,
         country,
         state
FROM customers
WHERE country = 'USA'
        AND state = 'CA';

#3

SELECT   customername,
         country,
         state,
         creditlimit
FROM customers
WHERE country = 'USA'
        AND state = 'CA'
        AND creditlimit > 100000;

Table List

customers

SELECT * FROM customers;

employees

SELECT * FROM employees;

offices

SELECT * FROM offices;

orderdetails

SELECT * FROM orderdetails;

orders

SELECT * FROM orders;

payments

SELECT * FROM payments;

productlines

SELECT * FROM productlines;

products

SELECT * FROM products;

SQL Query

Execute

Clear Beautify Minify

Result