IS NOT boolean_value

IS NOT boolean_value

Syntax

MYSQL Copy

SELECT 1 IS NOT UNKNOWN, 0 IS NOT UNKNOWN, NULL IS NOT UNKNOWN;
1, 1, 0

Examples

Example

Tests a value against a boolean value, where boolean_value can be TRUE, FALSE, or UNKNOWN.

MYSQL Copy

SELECT 1 IS NOT UNKNOWN, 0 IS NOT UNKNOWN, NULL IS NOT UNKNOWN;
1, 1, 0