This page is part of the book SQL-99 Complete, Really, by Peter Gulutzan & Trudy Pelzer. The authors have graciously allowed us to reproduce the contents of the book here. Because the book is about the SQL-99 standard, the contents of this and other pages in the book may not directly apply to MariaDB. Use the navigation bar to navigate the book.

In SQL, a Boolean value either TRUE, FALSE or UNKNOWN is a truth value. A Boolean value may be a <literal>, the value of a parameter or a host language variable or the result of any expression or argument (including a possibly qualified <Column name> or the result of an SQL predicate or search condition) that evaluates to a truth value. Boolean values are stored in the Boolean <data type>: BOOLEAN.