MySQL Forums :: Transactions :: ROW_NUMBER Simulation

Hi!

I'm looking for a solution to simulate the ROW_NUMBER() OLAP Function know in other Database like Oracle, Teradata or DB2.

One solution is:
SET @rank = 0;

SELECT name,
(@rank := IF(@prev_name=name,@rank+1,1)) AS rownumb,
(@prev_basket := name)

But I don't know why for example, testing in querybrowser, the var @rank won't be set. The var ist always NULL. So that mean that the colum rownumb will always be 1.
I have the same when I do it in perl.

Have I set any systemvar for using vars?

thx
Michael