MySQL "DISTINCT" query
| From: | Jared Howard | Date: | Wed, 21 Mar 2001 18:04:48 +0000 |
| Subject: | MySQL "DISTINCT" query | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-44975@lists.php.net to get a copy of this message | ||
I need to retrive all column information from a DISTINCT query. But so
far, I only can get one column to show by using this:
SELECT DISTINCT my_column FROM my_table;
which then gives me a list of my_column information and is correct, but I
need all information from all columns. Querying this:
SELECT DISTINCT my_column, my_column2, my_column3, my_column4 FROM my_table;
was my guess at it, but doesn't work how I'd like.