SELECT DISTINCT or GROUP_CONCAT on table and show multiple fields

[rotrax]

Hi There,

is there a way to show only unique records in a table based on two field instead of one.

i tried

SELECT DISTINCT field1, field2 works only for on field
SELECT field1GROUP_CONCAT(field2)

can’t get i right.

so in the table each record has two unique fields, based on this fields i only want to choose one of those records. (don’t display the same records, only one unique one)

[aamartinezz]

Hi,
try

SELECT field1, GROUP_CONCAT(field2)
FROM table
group by field1