How do you write a conditional in a MySQL select statement?

I'm using MySQL, and I want to do a sort of ternary statement in my SQL like:

SELECT USER_ID, ((USER_ID = 1) ? 1 : 0) AS FIRST_USER
  FRO开发者_StackOverflow社区M USER

The results would be similar to:

USER_ID | FIRST_USER
1       | 1
2       | 0
3       | 0
etc.

How does one accomplish this?

---

SELECT USER_ID, (CASE USER_ID WHEN 1 THEN 1 ELSE 0 END) as FIRST_USER FROM USER

---

SELECT USER_ID, IF(USER_ID = 1, 1, 0) AS FIRST_USER FROM USER

The IF() statement works similarly to the ternary ? : operator.