update the_table set price=price*1.2 where material='iron'
update the_table set price=price*1.1 where material='plastic'
##</code><code>##

update the_table set price=17.54 where the_key=123
update the_table set price=1.50 where the_key=125
update the_table set price=15.00 where the_key=126
...etc...

##</code><code>##

update the_table set price=price*2 where material='iron'
update the_table set drop_ship=1 where is_heavy=1 or is_large=1