selecting records on a random basis with mysql function rand possible?
| From: | andy | Date: | Tue, 07 May 2002 12:52:31 +0000 |
| Subject: | selecting records on a random basis with mysql function rand possible? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-19007@lists.php.net to get a copy of this message | ||
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)
Thanx, Andy