Ah that's sheer genius!
Thanks muchly, I never figured in to being able to use SQL with it's own
"variables" so to speak - I'm sure I'll find more than one use for this new
Much appreciated Ed :)
----- Original Message -----
To: <admin@stripped>; <mysql@stripped>
Sent: Tuesday, February 10, 2004 3:19 PM
Subject: RE: A "current row updating" counter for a mass "Update" or
Sure, try this. I'm using 4.1.2 in case it matters.
SET Rank= (select @n:=@n+1)
ORDER BY Score DESC;