- 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:
eem 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
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
