!
Syntax
NOT, !
Contents
Description
Logical NOT. Evaluates to 1 if the operand is 0, to 0 if the operand is non-zero, and NOT NULL returns NULL.
By default, the !
operator has a higher precedence. If the HIGH_NOT_PRECEDENCE
SQL_MODE flag is set, NOT
and !
have the same precedence.
Examples
SELECT NOT 10; +--------+ | NOT 10 | +--------+ | 0 | +--------+ SELECT NOT 0; +-------+ | NOT 0 | +-------+ | 1 | +-------+ SELECT NOT NULL; +----------+ | NOT NULL | +----------+ | NULL | +----------+ SELECT ! (1+1); +---------+ | ! (1+1) | +---------+ | 0 | +---------+ SELECT ! 1+1; +-------+ | ! 1+1 | +-------+ | 1 | +-------+
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.