Need help with sql update request

Question

I have tabular “products” and I need to update the “price” field by 20% if the product type field is “imported”.
How can I read and update a field at the same time in my UPDATE query?

Answer 1

This can be done using the SQL Update statement :

 UPDATE products SET price = price * 1.2 WHERE type = 'Imported' 

This will increase the price all imported products by 20%.

Answer 2

This should do the trick:

UPDATE products SET price = (price * 1.2) WHERE type = 'imported'