select unique records with all fields in mysql

[ZABI]

hi all, i m getting a problem with a query, i want to select records having unique values in field2 while field1 is primary key...

so when i run the

SELECT DISTINCT(field2) FROM table

it goes fine but i get only one field in result.

when i try this

SELECT DISTINCT(field2),field1,field3,field4,field5,field6,field7,field8,field9,field10 FROM table

i get all fields but not unique values in field2