MySQL : Stergere articole duplicat

Pentru a sterge articolele duplicat dintr-o tabela MySQL se foloseste DISTINCT astfel :
DELETE FROM table1 USING table1, table1 AS vtable WHERE (table1.id > vtable.id) AND (table1.field_name=vtable.field_name)