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:

title	count
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.