Querying Data with MySQL IN Operator: Examples

Examples
Sample Database

#1

SELECT
	officeCode,
	city,
	phone
FROM
	offices
WHERE
	country IN ('USA', 'France');

#2

SELECT
	officeCode,
	city,
	phone
FROM
	offices
WHERE
	country = 'USA'
OR country = 'France';

#3

SELECT
	officeCode,
	city,
	phone
FROM
	offices
WHERE
	country NOT IN ('USA', 'France');

#4

SELECT 
    orderNumber, customerNumber, status, shippedDate
FROM
    orders
WHERE
    orderNumber IN (SELECT 
            orderNumber
        FROM
            orderdetails
        GROUP BY orderNumber
        HAVING SUM(quantityOrdered * priceEach) > 60000);

#5

SELECT 
    orderNumber
FROM
    orderdetails
GROUP BY orderNumber
HAVING SUM(quantityOrdered * priceEach) > 60000;

#6

SELECT
	orderNumber,
	customerNumber,
	STATUS,
	shippedDate
FROM
	orders
WHERE
	orderNumber IN (10165, 10287, 10310);

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;

Result