Re: [PHP-DB] Pick a row, any row.

[Johannes Janson]

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]