mysql批量更新不同记录时使用update 结合case、when

在开发过程中，有时候会碰到批量更新的操作，如果一条一条的更新，数据越多，执行的次数就越多，很不理想；还有有case when 方法：

使用一条一条更新

UPDATE tb_video_tj SET play_num = 6 ,play_end_num =1 where dat='2022-03-30' and video_id=1;
UPDATE tb_video_tj SET play_num = 1 ,play_end_num =1 where dat='2022-03-30' and video_id=2;
UPDATE tb_video_tj SET play_num = 1 ,play_end_num =1 where dat='2022-03-30' and video_id=3;
UPDATE tb_video_tj SET play_num = 1 ,play_end_num =1 where dat='2022-03-30' and video_id=5;

如果是一百条就要执行一百次，徒增数据库资源，有没有更好的sql语句呢

使用update 和 case when方法

语句: UPDATE table_name SET filed = CASE filedWhere WHEN filedWhereVal THEN filedVal END

UPDATE tb_video_tj SET 
play_num = CASE video_id  WHEN 1 THEN 6 WHEN 2 THEN 1 WHEN 3 THEN 1 WHEN 5 THEN 1 END,
play_end_num = CASE video_id  WHEN 1 THEN 1 WHEN 2 THEN 1 WHEN 3 THEN 1 WHEN 5 THEN 1 END
 where dat='2022-03-30' and video_id in(1,2,3,5)