A client is using the Drupal node title module and, as part of an SEO review, I want to see how many duplicate meta titles there are. The following is a simple MySQL statement that I ran to get the answer:
SELECT DISTINCT(page_title) as title, count(page_title) AS count FROM page_title GROUP BY page_title HAVING count > 1
This will return a result like this:
|Buy a green widget||2|
|Buy a blue widget||3|
|About blue widgets||2|
So in this case, the title “Buy a green widget” is used 2 times.
This is a good example of how to get a count of duplicate values for a MySQL table.