mysql - 如何在不同条件下更新一个字段

Question

UPDATE `products_description` SET 
`products_name` = 'Name 1' WHERE language_id = 1 AND products_id = 2249,
`products_name` = 'Name 2' WHERE language_id = 2 AND products_id = 2249,
`products_name` = 'Name 3' WHERE language_id = 7 AND products_id = 2249 ;

我需要使用一个查询更新 3 行。谢谢!

Answer 1

你可以试试这个:-

UPDATE products_description
SET products_name = (
  CASE language_id 
    WHEN 1 THEN 'Name 1'
    WHEN 2 THEN 'Name 2'
    WHEN 7 THEN 'Name 3'
  END
)
WHERE products_id = 2249;