SQL update - price change

[Xiem]

Hello there =)

Is it possible to make something like:

 

UPDATE `traders_data` SET qty=10 WHERE `item` LIKE '%ItemVault%' AND qty=0;

 

 

But for price change? We want to change price of meds in our server, but doing this manualy takes way too long. Anyone willing to share their knowledge?

 

 

Also, i just noticed that i posted this in wrong place...