Want to update column to colum value in Magento2 update query

by |Published January 21, 2022

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