<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="boolean-literals">
      </a>
      11.1.6 Boolean Literals
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045220111536">
  </a>
  <a class="indexterm" name="idm46045220110048">
  </a>
  <a class="indexterm" name="idm46045220108976">
  </a>
  <a class="indexterm" name="idm46045220107904">
  </a>
  <p>
   The constants
   <code class="literal">
    TRUE
   </code>
   and
   <code class="literal">
    FALSE
   </code>
   evaluate to
   <code class="literal">
    1
   </code>
   and
   <code class="literal">
    0
   </code>
   , respectively. The constant names can be
        written in any lettercase.
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa84673102"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">SELECT</span> <span class="token boolean">TRUE</span><span class="token punctuation">,</span> <span class="token boolean">true</span><span class="token punctuation">,</span> <span class="token boolean">FALSE</span><span class="token punctuation">,</span> <span class="token boolean">false</span><span class="token punctuation">;</span>
<span class="token prompt">        -&gt;</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">0</span><span class="token punctuation">,</span> <span class="token number">0</span></code></pre>
  </div>
 </div>
 <br/>
</div>
