Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 43.3Mb
PDF (A4) - 43.4Mb
Man Pages (TGZ) - 297.3Kb
Man Pages (Zip) - 402.5Kb
Info (Gzip) - 4.3Mb
Info (Zip) - 4.3Mb
Excerpts from this Manual

MySQL 8.0 Reference Manual  / ...  / Language Structure  / Literal Values  /  Boolean Literals

11.1.6 Boolean Literals

The constantsTRUE andFALSE evaluate to1 and0, respectively. The constant names can be written in any lettercase.

mysql> SELECT TRUE, true, FALSE, false;        -> 1, 1, 0, 0