How to delete duplicate record from table in mysql Get link Facebook X Pinterest Email Other Apps September 06, 2011 delete from table1 USING table1, table1 as vtable WHERE (table1.ID > vtable.ID) AND (table1.field_name=vtable.field_name) Read more