At 3:16 PM -0800 10/31/01, Mike wrote: >Okay, say I have a database with 10,000 entries in it. All entries >have a unique id, but that ID is not exactly sequential (in fact, >it's a 128-bit checksum). > >Now, given that ID, I need to find out what row # in the grand >scheme that it is.
There's no such concept. Relational tables are sets, with no notion of row number. I'm curious what such a number would give you that the ID won't. You certainly wouldn't be able to use it later to identify the record. > >Let's take this test statement: > >SELECT * FROM auction ORDER BY lotnum ASC > >Is there any way I can add something to that, that might return what >row# a certain item is, using a WHERE condition? You can use this trick, though perhaps it's not what you want: SET @n = 0; SELECT @n:=@n+1 AS rownum, auction.* FROM auction ORDER BY lotnum ASC; Requires MySQL 3.23.6 or later. > >Mike --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
