NOT : NOT : Logic Operator MySQL TUTORIALS

MySQL TUTORIALS » Logic Operator » NOT »

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)

Related Scripts with Example Source Code in same category :

Using NOT with integer value
Using NOT with NULL value
SELECT NOT (1 + 1);

MySQL TUTORIALS

Logic Operator
» NOT

Aggregate Functions

Cast Functions Operators

Comparison Functions Operators

Control Flow Functions

Cursor

Data Dictionary

Data Types

Database

Date Time Functions

Encryption Compression Functions

Information Functions

Insert Update Delete

Introduction

Logic Operator

Math Numeric Functions

Miscellaneous Functions

Privilege

Subquery

Table

Table Join

Trigger

View

NOT : NOT : Logic Operator MySQL TUTORIALS

MySQL TUTORIALS » Logic Operator » NOT »

NOT

Leave a Comment / Note

MySQL TUTORIALS