Want to update column to colum value in Magento2 update query

Hello all I want to write a query magento 2 update query way where I can update 1 column value to another column value as below

update table_name set column1 = column2 where id =1;

Please help