mysql case when 语句应用,根据字段不同值返回不同的别名

废话不多说,直接上sql语句

SELECT
	inv.id AS '编号',
	m.id AS '创客编号',
	p.company AS '省代公司名称',
	inv.NAME AS '创客姓名',
	inv.maker_status AS '创客状态',(
	CASE
			
			WHEN inv.maker_status = 0 THEN
			'邀请创客' 
			WHEN inv.maker_status = 1 THEN
			'邀请注册创客' ELSE inv.maker_status 
		END 
		) 创客状态,
		inv.`status` AS '审核状态',(
		CASE
				
				WHEN inv.`status` = 0 THEN
				'待审核' 
				WHEN inv.`status` = 1 THEN
				'已通过' 
				WHEN inv.`status` = 2 THEN
				'已拒绝' ELSE inv.maker_status 
			END 
			) 审核状态,
			inv.phone AS '联系号码',
			inv.create_time AS '提交意向日期' 
		FROM
			invite_maker_record AS inv
			LEFT JOIN maker AS m ON inv.account_id = m.account_id 
			AND inv.phone = m.phone_number 
			AND m.del_flag = 0 
			AND m.default_flag = 0
			LEFT JOIN provincial_agent AS p ON inv.provincial_agent_id = p.id 
		AND p.del_flag = 0 
	AND p.default_flag = 0