On Sun, Dec 29, 2002 at 11:43:35AM -0500, Michael She wrote: > > > BTW, does MySQL have a RowNumber function?
You can use variables: select @a := 0; select id, more, fields, @a:= @a + 1 as rownumber from whatever; But you cannot use that number in the where part. Good luck. (sql, etc) -- The Moon is Waning Crescent (21% of Full) nieuw.nl - 2dehands.nl: 58038 --------------------------------------------------------------------- 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