Posted by Captain Paralytic on 02/21/07 10:12

On 21 Feb, 02:00, "David Smithz" <dave1...@blueyonder.co.uk> wrote:
> "Paul Lautman" <paul.laut...@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?

This one works

UPDATE `exampletable`
SET `field1` = @tmp := `field1`, `field1` = `field2`,
`field2` = @tmp
WHERE `field3` = value

[Back to original message]