To update a column using the values from another column in the same table, use the following query:
Update Table_Name Set Column1 = Column2
Where,
Table_name is the Table to be updated
Column1 is the colum that needs to be updated
Column 2 is the column from which the value needs to be taken
