Skip to content

BETWEEN ... AND ...

Description

If expr is greater than or equal to min and expr is less than or equal to max, BETWEEN returns true, otherwise it returns false.

Syntax

> expr BETWEEN min AND max

Examples

> SELECT 2 BETWEEN 1 AND 3, 2 BETWEEN 3 and 1;
+-------------------+-------------------+
| 2 between 1 and 3 | 2 between 3 and 1 |
+-------------------+-------------------+
| true              | false             |
+-------------------+-------------------+
1 row in set (0.01 sec)
> create table t (id bigint unsigned, b int);
> insert into t values(8894754949779693574,1);
> insert into t values(8894754949779693579,2);
> insert into t values(17790886498483827171,3);
> select count(*) from t where id>=8894754949779693574 and id =17790886498483827171 order by 1 asc;
+----------+
| count(*) |
+----------+
|        0 |
+----------+
> select count(*) from t where id between 8894754949779693574 and 17790886498483827171;
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.01 sec)