How can i change the value of an item with a assign value?

Question

I want to change the value of an item to a new value when the value is less than a certain value..
like change 1000 to 5000 when 1000 is less than 2000

Answer 1

Update table set value = 5000 where value < 2000;

add more conditions to where if necessary.

Answer 2

Alright thanks, it worked 😘😘😘😘