In this tutorial I am sharing the code how to delete duplicate entries from MySQL database based on a field_name.
Below SQL script creating table in a MYSQL database:
CREATE TABLE IF NOT EXISTS `product` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`item_code` varchar(255) NOT NULL,
`cat_id` int [...]