mysql distinct query

[Manat]

Hi all,

On the PhpMyAdmin interface for MySQL, is there an SQL command I can put there to delete all duplicates?  I have an auto-increment field, so not the entire row will be a duplicate, just two fields.

field1 field2 field3 field4
field1 field2 fieldx fieldx

See the first two are the same, I want one, not both, deleted.

any way?

thanks

[Pig]

These are not duplicate rows. This is an atypical situation where parts of the rows are duplicates. There is no feature in PMA to do this. You would have to create a custom script to do this.

[Manat]

custom script in php right?

Can you give me a few pointers how I would create such a script?

Delete from table where??????

[Pig]

There might be a way to do it with a SQL statement, but I don't know it. I would just create an array from table and work with that. Once you have it cleaned up, truncate the table and insert.