UPDATE git_version SET update_time = 2023-07-24 131054 status = CASE WHEN status = 0 THEN 0 ELSE CASE WHEN id = 114 THEN 1 ELSE 0 END END WHERE status 2;目前我想将固定id的状态变为1 如果有status=1的则变为0 status=0

UPDATE git_version SET update_time = '2023-07-24 13:10:54', status = CASE WHEN status = 0 THEN 0 ELSE CASE WHEN id = 114 THEN 1 ELSE 0 END END WHERE status <> 2 AND (status = 1 OR status = 0);