How do you write a conditional in a MySQL select statement?
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.