mysql case when thenÓ÷¨

SELECT
	CASE
WHEN b.is_leave = 0 THEN
	'ÔÚÖ°'
WHEN b.is_leave = 1 THEN
	'ÀëÖ°'
ELSE '״̬Ϊ¿Õ'
END
FROM
	sys_user_front a
LEFT JOIN sys_org_emp b ON a.info_id = b.info_id
WHERE
	1 = 1
AND a.login_name = '3111111';