SELECT DISTINCT

[j j]

I am trying to delete duplicate rows by transferring distinct records into a temp table, then deleting the records in the original table and inserting the temp back into the oringial

I want to return all rows from table1 where field1 is unique using the SELECT DISTINCT command.

SELECT DISTINCT `field1`FROM `table1`

This command only returns the field `field1` from each row. How can I return all fields in a row?

Running MySQL-Server-3.23.58-9.1