SQL query to update 2000+ fields in 'Value' column within 'ps_discount'

[Lucas-911]

Hello,

 

I need to update 2000+ fields in the table ps_discount - 'value'.

 

The fields are within 'id_discount' 360812 – 362811 and would like to insert a new £x amount within the 'value' field....

 

I know its a simple SQL query but cannot figure it out...

 

Any help will be much appreciated... Will send $20 asap as soon SQL query updates all fields correctly

 

Cheers

[Vinum]

UPDATE ps_discount SET value=X WHERE id_discount BETWEEN 360812 AND 362811

 

or

 

UPDATE ps_discount SET value=X WHERE id_discount >= 360812 AND id_discount <= 362811

 

replace X by your amount

[NemoPS]

Small addition: if you want to increase every discount, you can also do this:

UPDATE ps_discount SET value=value+X WHERE id_discount BETWEEN 360812 AND 362811

Where x, in this case, is the amount by which you want to increase all discounts