Changing price for all items at same time

[schoolboy]

I'd like to change by a percentage . . . can I use:

UPDATE products SET products_price= products_price x .90909;

I want to change prices to 10/11 of what they are now, just not sure how to do that in SQL

Thanks, Sean

That should be OK. Use * not x for "multiply". It will change ALL prices.

[smcelligott]

That should be OK. Use * not x for "multiply". It will change ALL prices.

Schoolboy, yep tried "x" yesterday and it failed, then tried * and it worked just fine. On a related issue, I had some rounding issues. Is there a SQL statement that can modify a product price of $126.36364 to just $126.36?

[RodG]

Schoolboy, yep tried "x" yesterday and it failed, then tried * and it worked just fine. On a related issue, I had some rounding issues. Is there a SQL statement that can modify a product price of $126.36364 to just $126.36?

http://www.w3resource.com/mysql/math...d-function.php

Cheers
Rod