[PHP-DB] Exclude indentical values

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

RE: [PHP-DB] Exclude indentical values

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).

Re: [PHP-DB] Exclude indentical values

ok, sorry about that :-) Table: BlaID BlaInfo 20 4 17 8 20 9 15 81 20 12 20 23 17 0 Result: BlaID BlaInfo 15 81 17 0 20 9 I don't realy care about the value's I get in BlaInfo as long as I get one of those value's... I asume this is a very simple instruction but I just

Re: [PHP-DB] Exclude indentical values

SELECT BlaID, MAX(BlaInfo) AS Info FROM mytable GROUP BY BlaId Prodoc [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... ok, sorry about that :-) Table: BlaID BlaInfo 20 4 17 8 20 9 15 81 20 12 20 23 17 0 Result: BlaID BlaInfo 15 81 17 0