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