MYSQL row position.. is it possible (urgent)
| From: | Mike | Date: | Fri, 04 Mar 2005 22:20:27 +0000 |
| Subject: | MYSQL row position.. is it possible (urgent) | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-38774@lists.php.net to get a copy of this message | ||
Let's say I have a database and I want to find the position of a row when it is ordered by a
specific column
before a sort:
UNIQUE ID | SCORE
000000001 | 100
000000002 | 50
000000003 | 30
000000004 | 80
000000005 | 50
after sort:
UNIQUE ID | SCORE
000000001 | 100
000000004 | 80
000000002 | 50
000000005 | 50
000000003 | 30
is it posible to find the position of 000000004 with a query or mysql function?
Normally I'd just 'SELECT unique_id FROM table ORDER DESC' then loop through the
results looking for a matching id, however my table contains thousands of entries, and it's
simply not possible do do it that way.
Thanks
Mike