SQL BETWEEN 연산자

개요

SQL BETWEEN Operator
SQL BETWEEEN 연산자

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

예시 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';

예시 2: 날짜/시간

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

실행예시

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)

같이 보기

참고

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