SQL Capabilities Question

[Magic2K2]

Let's say I execute a query that returns 200 results. Each row in the result contains a primary field called "player_id". Now, for example, I want to find out which row player_id = 123. Can SQL tell me if that player_id is in the 10th, 20th, or whatever row? I know I could do a loop and count it myself, but I'd rather this shortcut if its possible.

 

[Jome]

I don't understand your question fully.

You could use SELECT * FROM table WHERE player_id = 133, but I'm not sure that's what you're looking for.

 

[ashben]

This works in MS-SQL:

select @@ROWCOUNT, * from TableName

.. where the first column would hold an incrementing row count for the respective record.

Hope it help!

 

[atlas]

It's not a standard part of SQL, but many SQL servers support it. What are you using? MySQL?