IS boolean_value

IS boolean_value

Syntax

MYSQL Copy

SELECT 1 IS TRUE, 0 IS FALSE, NULL IS UNKNOWN;
1, 1, 1

Examples

Example

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

MYSQL Copy

SELECT 1 IS TRUE, 0 IS FALSE, NULL IS UNKNOWN;
1, 1, 1