DELETE FROM online_supplier WHERE id NOT IN ( SELECT a.id FROM( SELECT id,NAME FROM online_supplier GROUP BY NAME ) a )