How do you write a conditional in a MySQL select statement? February 21, 2023 by Tarik SELECT USER_ID, (CASE USER_ID WHEN 1 THEN 1 ELSE 0 END) as FIRST_USER FROM USER