Posted by Norman Peelman on 02/21/07 11:29

Captain Paralytic wrote:
> 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
>

They both work. And yes, another good example. You need to use := to
set the variable and = to read it.

Norm

[Back to original message]