SQL Update if Column = then Update

Question

嗨，我写了这个查询，但是它给了我错误的语法错误。我正在尝试更新BizValue，如果BUSINESS_UNIT = 'Value‘，则将BizValue更新为1...

请帮帮忙

UPDATE products.products 
SET BizValue = CASE BizValue 
        WHEN BUSINESS_UNIT='Optoelectronics' THEN 1
        WHEN BUSINESS_UNIT='Hardware' THEN 2 
        ELSE null
      END 

Answer 1

从CASE部件中取出BizValue：

UPDATE products.products 
SET BizValue = CASE 
        WHEN BUSINESS_UNIT='Optoelectronics' THEN 1
        WHEN BUSINESS_UNIT='Hardware' THEN 2 
        ELSE null
      END 

或

UPDATE products.products 
SET BizValue = CASE BUSINESS_UNIT
        WHEN 'Optoelectronics' THEN 1
        WHEN 'Hardware' THEN 2 
        ELSE null
      END