How to copy a column into another column?

[Archbob]

If I want to copy a column in a mysql database to another column in mysql database, how is this done?

[tsinka]

A column in the same table or in another table ?

[Archbob]

same table.

[tsinka]

Hi,

this should work:

if you have a table with id,field1 and field2 then try:

UPDATE thetable SET field1=field2 WHERE id=theid;

without ' around field2. I can't test it now but it should work.

[Archbob]

Thanks.