Posted by Norman Peelman on 02/21/07 04:10

David Smithz wrote:
> "Paul Lautman" <paul.lautman@btinternet.com> wrote in message
> news:5416e9F1ug8raU1@mid.individual.net...
> In fact I have now managed to try it on an isolated row that I fixed
> afterwards and unfortunately it works how I don't want it to. Therefore both
> the fields become the same value.
>
> So how can I achieve this?
>
>

David,

Use either multiple queries or user-defined variables. Try this
(given a table with fields `A` and `B`:

UPDATE tablename SET A = B, B := @tmp WHERE @tmp := A

Nice one liner SQL that swaps two fields. :)

Norm
....the WHERE clause gets evaluated first.

[Back to original message]