sql使用update set case when 实现一条语句批量更新

比如有一张user表  有字段username（用户名），status（状态）   

表中有三条数据 username = "张三" status = 1，username = "李四" status = 0， username = "王五" status = 1

现在要将username更新为拼音,sql如下

UPDATE USER
SET username = (
	CASE username
	WHEN "张三" THEN "zhangsan"
	WHEN "李四" THEN "lisi"
	WHEN "王五" THEN "wangwu"
	ELSE username END
)

现在要将username为张三和王五的用户status改为0

UPDATE USER 
SET STATUS = (
CASE 
WHEN username="张三" then 0
when username="王五" then 0
else username end
)