CODE EXAMPLE FOR SQL

remove duplicates mysql

DELETE c1 FROM addresslist c1
INNER JOIN addresslist c2 
WHERE
    c1.id > c2.id AND 
    c1.`city` = c2.`city` AND
    c1.`province` = c2.`province` AND
    c1.`pgiRegion` = c2.`pgiRegion`