SQL 비교 연산자

SQL Comparison Operators

SQL WHERE 절 연산자

SQL 비교 연산자

1 목록

연산자	설명	예시
=	같음	SELECT * FROM fruits WHERE price=100
!=	같지 않음	SELECT * FROM fruits WHERE price!=100
<>	같지 않음	SELECT * FROM fruits WHERE price<>100
<	작음	SELECT * FROM fruits WHERE price<100
>	큼	SELECT * FROM fruits WHERE price>100
<=	작거나 같음	SELECT * FROM fruits WHERE price<=100
>=	크거나 같음	SELECT * FROM fruits WHERE price>=100
!<	작지 않음	SELECT * FROM fruits WHERE price!<100
!>	크지 않음	SELECT * FROM fruits WHERE price!>100
BETWEEN	두 값 사이에 있음	SELECT * FROM fruits WHERE price BETWEEN 100 AND 200
NOT BETWEEN	두 값 사이에 있지 않음	SELECT * FROM fruits WHERE price NOT BETWEEN 100 AND 200
IS NULL	NULL임	SELECT * FROM fruits WHERE id IS NULL
IS NOT NULL	NULL이 아님	SELECT * FROM fruits WHERE id IS NOT NULL

2 같이 보기

• SQL 논리 연산자
• WHERE 절
• BETWEEN 연산자
• IS NULL, IS NOT NULL
• 연산자

3 참고

• http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html
• http://www.tutorialspoint.com/sql/sql-operators.htm