Re: selecting random rows
| From: | Leif K-Brooks | Date: | Fri, 28 Feb 2003 04:57:31 +0000 |
| Subject: | Re: selecting random rows | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25989@lists.php.net to get a copy of this message | ||
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.