Re: selecting records on a random basis with mysql function rand possible?
| From: | Jason Wong | Date: | Tue, 07 May 2002 13:09:45 +0000 |
| Subject: | Re: selecting records on a random basis with mysql function rand possible? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-19009@lists.php.net to get a copy of this message | ||
On Tuesday 07 May 2002 20:52, andy wrote:
> Hi there,
>
> is it possible to get mysql to return a record out of a table on a random
> basis?
>
> I tryed:
>
> select rand() ID, city
> from data.cities
> where country = 'CA'
> LIMIT 1
>
> but does not work though. Has anybody an idea? I tryed also to read all
> results and do the random thing with php, but this does take forever (doing
> it for a couple of times)
Try (won't work on older versions of mysql)
SELECT something, or_another FROM table ORDER BY RAND() LIMIT 1;
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
You knew the job was dangerous when you took it, Fred.
-- Superchicken
*/