(mysql) How to remove rows that are not unique for a certain field from a table?

Question

MySQL

Table:

8;privet
9;privet
10;hi
11;hello

Line 8 or 9 will be deleted - it doesn't matter. Can this be done in SQL?

Answer 1

Delete from the product_image table by the img field:

DELETE t1 FROM product_image t1
JOIN (SELECT MIN(id) AS minid, img FROM product_image GROUP BY img) t2 
ON t1.id <> t2.minid AND t1.img = t2.img

Answer 2

Banned on google? The first link:
www.cyberforum.ru/mysql/thread224262.html