Scott ----------Original Message---------
> What would be the most efficient query to determine the number of rows? > Probably something like SELECT COUNT(*) AS rectotal FROM table ? Cheers Terry PS - better to reply direct to list rather than individual, as you seem to have done on this occasion :-} > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 29, 2003 10:50 AM > To: [EMAIL PROTECTED] > Subject: Re: random start to query > > > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
