NOT

BUKAN, !

Syntax

MYSQL Copy

SELECT NOT 10;
0
SELECT NOT 0;
1
SELECT NOT NULL;
NULL
SELECT ! (1+1);
0
SELECT ! 1+1;
1

Contoh

Example

Logical NOT. Evaluates to 1 if the operand is 0, to 0 if the operand is nonzero, and NOT NULL returns NULL.

MYSQL Copy

SELECT NOT 10;
0
SELECT NOT 0;
1
SELECT NOT NULL;
NULL
SELECT ! (1+1);
0
SELECT ! 1+1;
1