UPDATE Products UPDATE Products SET sale_price = print_price * 0.5 WHERE print_price != 0.00 AND publish2 = 1;