SQL DISTINCT with MYSQL
| From: | Vernon | Date: | Fri, 14 Mar 2003 00:23:46 +0000 |
| Subject: | SQL DISTINCT with MYSQL | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-139625@lists.php.net to get a copy of this message | ||
I'm setting up a user online system using MySQL where I have 4 fields, all
of which is working fine.
I need the information from all the fields but want only distinct values
based on the uname column. If I use the:
SELECT DISTINCT uname
FROM useronline
of course I come back with the values I desire, but only the user names.
As I am also tracking the page they are on I need other columns in the table
as well. So the question is, using an SQL statement, how do I return only
distinct useronline.uname values from the database as well as the
useronline.file column?
Thanks