mysql multiple update with 2 x where
<p>I try to get multiple Mysql update queries in one query, I have 3 test queries </p>

<pre><code>UPDATE `stock` SET `date_time_out`='2016-12-05 13:47:05' WHERE `weighting_id` = '80' AND `date_time_out` = '0000-00-00 00:00:00'
UPDATE `stock` SET `date_time_out`='2016-12-05 13:46:05' WHERE `weighting_id` = '79' AND `date_time_out` = '0000-00-00 00:00:00'
UPDATE `stock` SET `date_time_out`='2016-12-05 13:45:05' WHERE `weighting_id` = '78' AND `date_time_out` = '0000-00-00 00:00:00'
</code></pre>

<p>I have created query following query, but it doesn'twork</p>

<pre><code>UPDATE `stock` 
SET value = CASE
WHEN  `weighting_id` = '80' AND `date_time_out` = '0000-00-00 00:00:00' THEN '2016-12-05 13:47:05'
WHEN  `weighting_id` = '79' AND `date_time_out` = '0000-00-00 00:00:00' THEN '2016-12-05 13:46:05'
WHEN  `weighting_id` = '78' AND `date_time_out` = '0000-00-00 00:00:00' THEN '2016-12-05 13:45:05'
ELSE VALUE
END
</code></pre>