Re: [PHP-DB] selecting random rows

[Leif K-Brooks]

select * from table order by rand() limit 2

[EMAIL PROTECTED] wrote:

I'm sure this is pretty simple, but I'm having a hard time finding the answer:

How do you select two random rows in a mysql table?

Thanks,
Kent
 

--
The above message is encrypted with double rot13 encoding.  Any unauthorized attempt 
to decrypt it will be prosecuted to the full extent of the law.


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php