此问题在此处已有答案:
MySQL update CASE WHEN/THEN/ELSE [duplicate](3个答案)
MySQL update case help(7个答案)
3天前关闭。
我需要根据两个WHERE条件更改一列。如何正确编写此查询?
UPDATE MyTable
SET `group_aso` = "REPACK"
WHERE
`REPACK` = "YES" AND `LABEL` = "NO"
OR
SET `group_aso` = "LABEL"
WHERE
`REPACK` = "NO" AND `LABEL` = "YES"
1条答案
按热度按时间hmae6n7t1#
您可以合并这些条件并使用条件case表达式,如下所示