Blair Wadman 1 minute read
February 3, 2011

Count of duplicate values in MySQL table

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:

titlecount
Buy a green widget2
Buy a blue widget3
About blue widgets2

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.