NOT BETWEEN … AND …

语法说明

NOT BETWEEN ... AND ... 操作符选取介于两个值之间的数据范围外的值。这些值可以是数值、文本或者日期。如果取值介于两值之间，那么返回 false，否则返回结果为 true。

语法结构

  1. > expr NOT BETWEEN min AND max

示例

  1. mysql> SELECT 2 NOT BETWEEN 1 AND 3, 2 NOT BETWEEN 3 and 1;
  2. +-----------------------+-----------------------+
  3. | 2 not between 1 and 3 | 2 not between 3 and 1 |
  4. +-----------------------+-----------------------+
  5. | false                 | true                  |
  6. +-----------------------+-----------------------+
  7. 1 row in set (0.00 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. +----------+
  12. mysql> select count(*) from t where id not between 8894754949779693574 and 17790886498483827171;
  13. +----------+
  14. | count(*) |
  15. +----------+
  16. |        3 |
  17. +----------+
  18. 1 row in set (0.00 sec)