Re: SQL field problem
| From: | Chris Hewitt | Date: | Wed, 10 Jul 2002 19:27:49 +0000 |
| Subject: | Re: SQL field problem | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-106933@lists.php.net to get a copy of this message | ||
Chris,
select distinct kat from tablename;
Its in the mysql manual, 6.4.1 SELECT Syntax.
HTH
Chris
mail@struempf.com wrote:
Hello I have a problem with mysql.I create a table with a field "kat".In this field are entries like this : Light Dark Dark Light Robot Find Dark Light You see that all entries are not unique.So i want to list as output all entries but only once.If the word "Dark" is in the table 6 times php should output dark only 1 time. How should i solve this problem ? Thanks! chris