- Original Message -
From: "Carter, Scott" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, 29 May, 2003 12:35
Subject: RE: random start to query
I think I found another answer to my own question. FYI a good way to return
resu
Great!Didn't know you could do that.
Cheers
Terry
--Original Message-
> I think I found another answer to my own question. FYI a good way to
> return
> results in a random order
> SELECT user FROM table ORDER BY RAND()
>
--
MySQL General Mailing List
For list archives:
: random start to query
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 s
one 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-
>
&
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 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
