MySQL increasing numeric values within a table?

mysql database functions - sums -

[population]

I have a database table which contains prices. I want to increase the price of every product in my store by 5%. Without manually editing every single record, is there a command I can execute which will automatically go in, retrieve the current prices, calculate the new prices and then update the column (or create the new value in a new column)?

Thanks!

Rick

[bobnew32]

$sql= "select * from table";
$result= mysql_query($sql);
while($row= mysql_fetch_array($result))
{

$update= "update table set value= value * '0.05' + value where id= '$row[id]'";
$res= mysql_query($update);

}

[population]

Thank you very much. I will give it a try!

Rick

[brucec]

or SET price=price*1.05 would work :)