php mysql 多次更新什么也不做

Question

$query = "UPDATE TABLE1 
  SET (row1 = '$val1' WHERE row5 = '$someid' AND active = 'yes')
    , (row1 = '$val2' WHERE row5 = '$someid' AND active = 'yes')
    , (row1 = '$val3' WHERE row5 = '$someid' AND active = 'yes')";

mysql_query($query);

此查询不执行任何操作。我无法更新数据。
我做错了什么？

Answer 1

UPDATE `table` SET `name`= case `id` 
    when 1 then "Alex"
    when 2 then "John"
    when 3 then "Steve"
 end 
WHERE `id` in(1,2,3)

不是吗？