The constants TRUE
and FALSE
evaluate to 1 and 0, respectively. The constant names can be written in any lettercase.
SELECT TRUE, true, FALSE, false;
+------+------+-------+-------+
| TRUE | TRUE | FALSE | FALSE |
+------+------+-------+-------+
| 1 | 1 | 0 | 0 |
+------+------+-------+-------+
This page is licensed: GPLv2, originally from fill_help_tables.sql