생각나는 MySQL 명령어 파보기 - 3

BETWEEN

특정 값이 주어진 두 값 사이에 있는지를 확인하는 데 사용

SELECT *
FROM products
WHERE price BETWEEN 10 AND 20;

SELECT *
FROM products
WHERE price NOT BETWEEN 10 AND 20;

 

IN

지정된 값 목록 중 하나와 일치하는지 확인하는 데 사용

SELECT *
FROM users
WHERE id IN (1, 3, 5);

SELECT *
FROM users
WHERE id NOT IN (1, 3, 5);

 

LIKE

 특정 패턴과 일치하는 값을 찾는 데 사용

SELECT *
FROM users
WHERE email LIKE '%@gmail.com';

SELECT *
FROM users
WHERE email NOT LIKE '%@gmail.com';

 

UNION

두 개 이상의 SELECT 문의 결과를 하나의 결과 집합으로 결합하는 데 사용

 

테이블에 중복을 제거한다.

SELECT customer_id
FROM orders
UNION
SELECT customer_id
FROM returns;

테이블에 중복을 제거하지 않고 모든 값이 나온다.

SELECT customer_id
FROM orders
UNION ALL
SELECT customer_id
FROM returns;