SQL NOT 연산자

1 개요

SQL NOT 연산자

• 조건을 부정할 때 사용하는 WHERE 절 키워드

2 예시

• '='과 조합

SELECT * FROM wp_terms WHERE term_id = 123;

SELECT * FROM wp_terms WHERE NOT term_id = 123;
SELECT * FROM wp_terms WHERE term_id <> 123;
SELECT * FROM wp_terms WHERE term_id != 123;

• LIKE와 조합

SELECT supplier_name FROM suppliers WHERE supplier_name LIKE 'T%';

SELECT supplier_name FROM suppliers WHERE supplier_name NOT LIKE 'T%';

• NULL 조건과 조합

SELECT * FROM vm_instance WHERE removed IS NULL;

SELECT * FROM vm_instance WHERE removed IS NOT NULL;

• IN 연산자와 조합

SELECT * FROM archive WHERE ar_id IN (123, 456, 789);

SELECT * FROM archive WHERE ar_id NOT IN (123, 456, 789);

• BETWEEN과 조합

SELECT * FROM suppliers WHERE supplier_id BETWEEN 5000 AND 5500;

SELECT * FROM suppliers WHERE supplier_id NOT BETWEEN 5000 AND 5500;

• EXISTS와 조합

SELECT * FROM suppliers WHERE EXISTS (SELECT * FROM orders WHERE suppliers.supplier_id = orders.supplier_id);

SELECT * FROM suppliers WHERE NOT EXISTS (SELECT * FROM orders WHERE suppliers.supplier_id = orders.supplier_id);

3 같이 보기

• SQL LIKE 연산자
• SQL IN 연산자
• SQL BETWEEN 연산자
• SQL EXISTS 연산자
• SQL 논리 연산자
• WHERE 절

4 참고

• http://www.techonthenet.com/sql/not.php