update the_table set price=price*1.2 where material='iron' update the_table set price=price*1.1 where material='plastic' #### 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... #### 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