Finding duplicate values in MySQL

SELECT DISTINCT(page_title) as title, count(page_title) AS count
FROM page_title
GROUP BY page_title
HAVING count > 1