IN, NOT IN

-- Select all customers from countries list
SELECT *
FROM customers
WHERE country IN ('Mexico', 'Germany');

-- Select all customers NOT from countries list
SELECT *
FROM customers
WHERE country NOT IN ('Mexico', 'Germany');