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?
Thanks in advance - Scott Carter -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
