Mysql Multiplication Query

Question

I have a table called a product containing a field called price, and I just want to double the price for each product. Could you give me a hand with an SQL statement that I can run in PHP myAdmin, please.

Answer 1

update products set price = price * 2; 

Answer 2

it's as simple as

 UPDATE products SET price = price*2; 

Answer 3

 UPDATE products SET price = price + price; 

Didn't want to use multiplication: P