Re: selecting random rows

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



select * from table order by rand() limit 2

kent@akseez.com 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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux