Sterge 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)