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

1. > expr BETWEEN min AND max

Examples

1. mysql> SELECT 2 BETWEEN 1 AND 3, 2 BETWEEN 3 and 1;
2. +-------------------+-------------------+
3. | 2 between 1 and 3 | 2 between 3 and 1 |
4. +-------------------+-------------------+
5. | true              | false             |
6. +-------------------+-------------------+
7. 1 row in set (0.01 sec)

1. create table t (id bigint unsigned, b int);
2. insert into t values(8894754949779693574,1);
3. insert into t values(8894754949779693579,2);
4. insert into t values(17790886498483827171,3);

6. mysql> select count(*) from t where id>=8894754949779693574 and id =17790886498483827171 order by 1 asc;
7. +----------+
8. | count(*) |
9. +----------+
10. |        0 |
11. +----------+

13. mysql> select count(*) from t where id between 8894754949779693574 and 17790886498483827171;
14. +----------+
15. | count(*) |
16. +----------+
17. |        0 |
18. +----------+
19. 1 row in set (0.01 sec)