increasing a price by a %

[chrisio]

Hi,
what would the syntax look like for increasing a field by a certain percentage rounded to 2 decimal points.

something like
set single_f = single_f *10% where ID =1

or am i miles off....


thanks
Chris

[chrisio]

never mind worked it out

UPDATE prices SET single_f = single_f/100*10+single_f
works for me!

thanks
chris

[r937]

alternatively, SET single_f = single_f * 1.1