MySQL get the row number

[Jeppe Sommer]

Hi,

Is it possible in mySQL (4.x) to get the row number using only a SQL query?

The result should be some like:

Row      ID           Name
1        000981       Peter
2        093388       Jane
3        000987       Alies
...

[ December 20, 2006: Message edited by: Jeppe Fjord ]

[Paul Clapham]

Here's the response that somebody from MySQL gave to that question when it was asked on MySQL's forum.