Mysql multiplication query
mysql, sql-update
Solution
update products set price = price * 2;
Problem
I have a table called products containing a field called price and I simply want to double the price on every product. Could you give me a hand with an SQL statement I can run within PHP myAdmin please.