Re: Quick MySql Question
| From: | Omar | Date: | Mon, 21 Oct 2002 23:42:47 +0000 |
| Subject: | Re: Quick MySql Question | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-120815@lists.php.net to get a copy of this message | ||
Try this:
SELECT DISTINCT(make) FROM 'table'
It'll show only 1 toyota, 1 honda, etc.
"Taylor York" <taylor@dreamstargroup.com> escribió en el mensaje
news:20021021222348.91182.qmail@pb1.pair.com...
> 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?
>
>
>
>
>