sql 查询替换结果，null换一个值，非null换一个值

sql 查询替换结果，null换一个值，非null换一个值

SELECT
	c.patrol_region,
	c.dept_id,
	c.patrol_person_id,
	c.create_time,
CASE
		c.id 
		WHEN '' THEN    //这里拿下面的‘’去判断换值
		'未完成' ELSE '已完成' 
	END AS stats_type 
FROM
	(
	SELECT
		a.patrol_region,
		a.dept_id,
		a.patrol_person_id,
		a.create_time,
		IFNULL( b.id, '' ) AS id //这里先把null的换成空
	FROM
		ai_patrol_detail a
	LEFT JOIN ai_patrol_record b ON a.id = b.patrol_detail_id 
	) c