returning unique values in columns
| From: | drparker at clam dot rutgers dot edu | Date: | Thu, 14 Nov 2002 21:17:11 +0000 |
| Subject: | returning unique values in columns | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-124498@lists.php.net to get a copy of this message | ||
Is there any way to run a query in mysql that retuns unique values in a
column? For example, say i had this colum:
Column:
---------
Fashion
---------
Basics
---------
Fashion
---------
Plus
--------
Plus
---------
but I only want it to return unique values - in this case I would only
want Fashion, Basics, Plus - instead of the Fashion, Basics, Fashion,
Plus, Plus I would get if I had run: SELECT column FROM tblname;
any help would be greatly appreciated...