the syntax "order by rand()"  is new in version 3.23


--
Regards,
Gary "SuperID" Huntress
=======================================================
FreeSQL.org offering free database hosting to developers
Visit http://www.freesql.org


""Johannes Janson"" <[EMAIL PROTECTED]> wrote in message
9e11f0$eog$[EMAIL PROTECTED]">news:9e11f0$eog$[EMAIL PROTECTED]...
> Hi,
>
> > How can I pick a random row?
>
> SELECT * FROM table ORDER BY RAND() LIMIT 0, 1;
> I'm not really sure but it worked with order by rand. Check
> the manual on that if it doesn't work
>
> hope it helps
> Johannes
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to