Mysql update && case when 联合使用 批量更新

直接码sql：

room字段值为 18F-N01 这种格式

UPDATE t_report SET room = CONCAT_WS( '-', SUBSTRING_INDEX(room, '-', 1) ,
	CASE SUBSTRING_INDEX(room, '-', -1) 
		WHEN 'N01' THEN 'N02' 
		WHEN 'N02' THEN 'N01'
		WHEN 'N03' THEN 'N11'
		WHEN 'N04' THEN 'N10'
		WHEN 'N05' THEN 'N09'
		WHEN 'N06' THEN 'N08'
		WHEN 'N07' THEN 'N07'
		WHEN 'N08' THEN 'N06'
		WHEN 'N09' THEN 'N05'
		WHEN 'N10' THEN 'N03'
	END )
WHERE rid IN ( 
	SELECT rid FROM t_report WHERE rdate = '190306' AND ordinal BETWEEN '23' AND '32'
)