Using NOT with integer value : NOT « Logic Operator « MySQL Tutorial






  1. MySQL Tutorial
  2. Logic Operator
  3. NOT
mysql>
mysql> SELECT ! (1+1);
+---------+
| ! (1+1) |
+---------+
|       0 |
+---------+
1 row in set (0.00 sec)

mysql> SELECT ! 1+1;
+-------+
| ! 1+1 |
+-------+
|     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);