title: How do you write a conditional in a MySQL select statement?
body: <p>I'm using MySQL, and I want to do a sort of ternary statement in my SQL like:</p>
  
  <pre><code>SELECT USER_ID, ((USER_ID = 1) ? 1 : 0) AS FIRST_USER
    FROM USER
  </code></pre>
  
  <p>The results would be similar to:</p>
  
  <pre><code>USER_ID | FIRST_USER
  1       | 1
  2       | 0
  3       | 0
  etc.
  </code></pre>
  
  <p>How does one accomplish this?</p>