Cacher is the code snippet organizer for pro developers

-- update address related info
update transactions
set billing_address = 'Cami del Pas, 4', billing_zip_code='03725',billing_city='Teulada'
where transaction_id = CONV('BMFL',36,10);

-- verify
select * from transactions where transaction_id = CONV('BMFL',36,10);