NOT,!

Description

Logical NOT,!. Evaluates to true if the operand is 0, to false if the operand is nonzero, and NOT NULL returns NULL.

Syntax

  1. > SELECT not column_name FROM table_name;

Examples

  1. mysql> select not 0;
  2. +-------+
  3. | not 0 |
  4. +-------+
  5. | true  |
  6. +-------+
  7. 1 row in set (0.02 sec)
  8. mysql> select not null;
  9. +----------+
  10. | not null |
  11. +----------+
  12. | NULL     |
  13. +----------+
  14. 1 row in set (0.00 sec)
  15. mysql> select not 1;
  16. +-------+
  17. | not 1 |
  18. +-------+
  19. | false |
  20. +-------+
  21. 1 row in set (0.01 sec)
  1. create table t1 (a boolean,b bool);
  2. insert into t1 values (0,1),(true,false),(true,1),(0,false),(NULL,NULL);
  4. mysql> select not a and not b from t1;
  5. +-----------------+
  6. | not a and not b |
  7. +-----------------+
  8. | false           |
  9. | false           |
  10. | false           |
  11. | true            |
  12. | NULL            |
  13. +-----------------+
  14. 5 rows in set (0.00 sec)

Constraints

! is not supported for now.