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:
|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.