Exchanging values between cells.

[Ob_server_]

Is it possible to exchange data between two cells in a mysql database?

[tha_mink]

It sure is.

UPDATE table SET table.column=table.othercolumn WHERE id = 'id'