I have a multiple-currency site. I've just physically transferred from a Euro country to the UK. I successfully used the following sql to update my site prices according to the current exchange rate at that time:
However, my default currency prices are now a bit messy, i.e. £3.61 or £4.39 (I probably should have used 0.85 instead of 0.83870798 in the sql). Is it possible to use a similar sql to round up all of the default currency prices to the nearest pound?
update products set products_price = products_price * '0.83870798';