Scott ----------Original Message---------
> I have a database table with say 100 rows. What I would like is to > preform > a query starting at a random place within the table, that will wrap > around > if I want it to. That is if the query starts returning results at the > 98th > row, then I would want it to return 98, 99, 100, 1, 2, ..... I know > that mysql has the RAND() function but how can I determine on the fly > how > many rows are in my table, and what would the SQL statement look like? > And > how can I get the query to wrap? > I'm a relative newcomer to this stuff myself, but you may have to do two separate queries for this - one to determine the row count, then another two-parter, using your random number in the first SQL (LIMIT) statement, with a UNION SQL statement to a similar query for the rest. Does that help? Terry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
