mysql - MySQL 排除之间的条目

Question

我有以下查询。我的目标是以某种方式排除 4 到 14 之间的条目而不显示它们。

SELECT code, register, data
    FROM code
    WHERE code
    BETWEEN 4
    AND 14
    ORDER BY code

Answer 1

只需在 code 列之后使用 NOT。

SELECT code, register, data
    FROM code
    WHERE code NOT
    BETWEEN 4
    AND 14
    ORDER BY code;

或者您也可以在 code 列之前使用“NOT”

SELECT code, register, data
    FROM code
    WHERE NOT code
    BETWEEN 4
    AND 14
    ORDER BY code;

只是see this SQLFiddle

引用。 MySQL: expr NOT BETWEEN min AND max