MYSQL – How to update a column using the value from another column in the same table?

To update a column using the values from another column in the same table, use the following query:

{code}

Update Table_Name Set Column1 = Column2

{/code}

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