Re: random record?
| From: | David Otton | Date: | Thu, 20 Sep 2001 14:35:27 +0000 |
| Subject: | Re: random record? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-67995@lists.php.net to get a copy of this message | ||
On Thu, 20 Sep 2001 10:35:59 -0400, you wrote:
>i'm looking to select a random record from a sql table. I remember seeing
>code for it on the list but fail to find it now. any help?
SELECT columns FROM table ORDER BY RAND() LIMIT 1
djo