I would like to update a database ranking in 1 swoop instead of ranking and then updating.
Here is my rank implementation:
SELECT @rank:=@rank+1 AS rank, id, fd1, fd2, fd3 FROM statsmsmobsters ORDER BY fd2 DESC, fd3 DESC;
I tried to do this and I get 0 results:
UPDATE dbTable SET rank_fd= @rank:=@rank+1 ORDER BY fd2 DESC, fd3 DESC;
Thanks for any help!