SELECT
    title, COUNT(title)
FROM
    cities
GROUP BY
    title
HAVING
    COUNT(title) > 1;

DELETE t1 FROM cities t1
INNER JOIN cities t2
WHERE
    t1.id < t2.id AND
    t1.title = t2.title;