cool! works. thanx, Andy
"Jason Wong" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED]... > 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 > */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php