Re: retrieving random data from mysql database
| From: | Chris Knipe | Date: | Sun, 14 Jul 2002 21:49:53 +0000 |
| Subject: | Re: retrieving random data from mysql database | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-107642@lists.php.net to get a copy of this message | ||
SELECT RANDOM name FROM table
or
SELECT name FROM table ORDER BY RANDOM LIMIT 1
not tested, used at your own free will.
--
me
----- Original Message -----
From: "mm fernandez" <mmr@lasaltech.com>
To: <php-general@lists.php.net>
Sent: Sunday, July 14, 2002 11:37 PM
Subject: [PHP] retrieving random data from mysql database
hi,
can you teach me how to retrieve random data from my database? like for
example...i have a list of names on my database and i'd like to retrieve
only one name at a time..randomly. how do i go about this?
hope someone can help...thanx.