Re: retrieve record position

[Peter Brawley]

SET @i=0;
SELECT x FROM (
  SELECT @i:=@i+1 AS x,name 
  FROM tbl
  ORDER BY datum
) AS r where r.name='Paul';

PB