select pr.*, round((pr.price * 1.2), 2 ) as 'round_price_2', round( (pr.price * 1.2) / 0.05, 0) * 0.05 as 'new_price_2_05' from xcart_pricing as pr where pr.membershipid = 0
use round( (pr.price * 1.2) / 0.05, 0) * 0.05 to round to the nearest 5p
update xcart_pricing as pr set pr.price = round( (pr.price * 1.2) / 0.05, 0) * 0.05 where pr.membershipid = 0 and pr.price > 0