RE: [PHP-DB] Exclude indentical values
| From: | Craig Vincent | Date: | Sat, 20 Apr 2002 14:23:57 +0000 |
| Subject: | RE: [PHP-DB] Exclude indentical values | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-18695@lists.php.net to get a copy of this message | ||
> Is it possible to exclude identical value's using a mysql query statment?
>
> E.g. I've got 2 colums named BlaID and BlaInfo.
> BlaID may contain 20 times the value 75 and 10 times the value 54.
> What I want to do is being able to retrieve the value 75 and 54 only
> once (with the vlue of BlaInfo).
>
> Is this possible to do with one statement?
I'm not sure what you're asking for. Are you saying if you had a table like
BlaID BlaInfo
75 100
54 125
75 90
54 110
You'd want a result like
------------------------------------
| BlaInfo | BlaID |
-------------------------------------
| | 75 |
| | 54 |
| 100 | |
| 125 | |
| 90 | |
| 110 | |
-------------------------------------
? Perhaps an example would clear things up of what you would like =)
Sincerely,
Craig Vincent