expr BETWEEN min AND max

expr ANTARA min DAN maks

Syntax

MYSQL Copy

SELECT 2 BETWEEN 1 AND 3, 2 BETWEEN 3 and 1;
1, 0
SELECT 1 BETWEEN 2 AND 3;
0
SELECT 'b' BETWEEN 'a' AND 'c';
1
SELECT 2 BETWEEN 2 AND '3';
1
SELECT 2 BETWEEN 2 AND 'x-3';
0

Contoh

Example

If expr is greater than or equal to min and expr is less than or equal to max, BETWEEN returns 1, otherwise it returns 0. This is equivalent to the expression (min

MYSQL Copy

SELECT 2 BETWEEN 1 AND 3, 2 BETWEEN 3 and 1;
1, 0
SELECT 1 BETWEEN 2 AND 3;
0
SELECT 'b' BETWEEN 'a' AND 'c';
1
SELECT 2 BETWEEN 2 AND '3';
1
SELECT 2 BETWEEN 2 AND 'x-3';
0