SQL BETWEEN 연산자

1 개요[ | ]

SQL BETWEEN Operator
SQL BETWEEEN 연산자

범위 내의 값(예: 숫자, 문자, 날짜)을 선택하는 연산자
시작값, 끝값 포함 ★

2 예시 1: 숫자/문자[ | ]

SELECT * FROM Products
WHERE Price BETWEEN 10 AND 20;

SELECT * FROM Products
WHERE Price NOT BETWEEN 10 AND 20;

SELECT * FROM Products
WHERE ProductName BETWEEN 'C' AND 'M';

3 예시 2: 날짜/시간[ | ]

SELECT * FROM Orders
WHERE created BETWEEN '2015-01-01' AND '2015-12-31';

4 실행예시[ | ]

mysql> SELECT * FROM employee;
+----+-----------+
| id | name      |
+----+-----------+
|  1 | 한놈      |
|  2 | 두시기    |
|  3 | 석삼      |
|  4 | 너구리    |
+----+-----------+
4 rows in set (0.00 sec)

mysql> SELECT * FROM employee WHERE id BETWEEN 1 AND 3;
+----+-----------+
| id | name      |
+----+-----------+
|  1 | 한놈      |
|  2 | 두시기    |
|  3 | 석삼      |
+----+-----------+
3 rows in set (0.00 sec)

5 같이 보기[ | ]

6 참고[ | ]

http://www.w3schools.com/sql/sql_between.asp