比如有一张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
)