NOT: ! : NOT « Logic Operator « MySQL Tutorial






  1. MySQL Tutorial
  2. Logic Operator
  3. NOT

Logical NOT.

Return 1 if the operand is 0.

Return 0 if the operand is non-zero.

mysql>
mysql> SELECT NOT 10;
+--------+
| NOT 10 |
+--------+
|      0 |
+--------+
1 row in set (0.00 sec)

mysql> SELECT NOT 0;
+-------+
| NOT 0 |
+-------+
|     1 |
+-------+
1 row in set (0.00 sec)








8.3.NOT
8.3.1.NOT: !
8.3.2.Using NOT with integer value
8.3.3.Using NOT with NULL value
8.3.4.SELECT NOT (1 + 1);