RE: [PHP-DB] Selecting one random column from MySQL
| From: | John Holmes | Date: | Wed, 18 Sep 2002 01:51:54 +0000 |
| Subject: | RE: [PHP-DB] Selecting one random column from MySQL | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-21815@lists.php.net to get a copy of this message | ||
> How can I select one random column from a MySQL table?
You can't, in one query. You can use the MySQL_ function to get a list
of all the columns, though, and then use PHP to select a random column
and construct an SQL statement.
If you need to do something like this, though, there is something wrong
in your database schema...
---John Holmes...