Finding duplicate values in MySQL

SELECT DISTINCT(page_title) as title, count(page_title) AS countFROM page_titleGROUP BY page_titleHAVING count > 1