[SOLVED] Update CASE not working

[Fruct0se]

All I am trying to do below is update the value of all columns +5 if the current value is below 995, if the value is above 995 but below 1000 then I want to set the value to 1000. Can anyone tell me why this is not working? I receive no errors and it always updates ENERGY to 0.

 

$db->query('UPDATE Users SET ENERGY = CASE WHEN ENERGY<996 THEN ENERGY=ENERGY+5 WHEN ENERGY>995 AND ENERGY<1000 THEN ENERGY=1000 ELSE ENERGY END');

 

 

SOLVED - I found that I cannot use the ENERGY column within the case, instead a simple +5 worked.