Re: Pick a row, any row.
| From: | Johannes Janson | Date: | Thu, 17 May 2001 17:28:41 +0000 |
| Subject: | Re: Pick a row, any row. | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-9415@lists.php.net to get a copy of this message | ||
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