Quick MySql Question
| From: | Taylor York | Date: | Mon, 21 Oct 2002 22:23:42 +0000 |
| Subject: | Quick MySql Question | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-120811@lists.php.net to get a copy of this message | ||
Hello, basically, I want a select with no duplicates...
I have a table similar to:
+----+--------+--------+
| id | model | make |
+----+--------+--------+
| 1 | Supra | Toyota |
+----+--------+--------+
| 2 | Civic | Honda |
+----+--------+--------+
| 3 | Celica | Toyota |
+----+--------+--------+
| 4 | Accord | Honda |
+----+--------+--------+
If I do a " SELECT make FROM
table " I will get 2 toyotas, and 2 hondas,
But what I want is just 1 toyota, and 1 honda.
Any suggestions?