how to increase column values by 20 percent using mysql

How do i increase the values in a column with percentage increment using MySQL, for example:

ID      price
1       500
2       800
3       450

How do i increase the values in price column by 20% using one sql query (MySQL)?

Simply calculate 20% of actual price:

update your_table
set price = price + (price * 20.0 / 100.0)
where id = (some condition)

or a shorter way:

update your_table
set price = price * 1.2
where id = (some condition)

StackExchange Database Administrators Q#141698, answer score: 8