Finding repeat occurrences in MySQL
Found myself diagnosing an issue today and my debugging journey led me to needing to determine how many records in a table shared the same value for a specific column. Figured this was something I could pretty easily find out with a well written query. After a little bit of tinkering, here is the gist of that query.
SELECT <target_column>,
count(*) AS times_used,
FROM <target_table>
GROUP BY <target_column>
HAVING times_used > 1
ORDER BY times_used DESC;
This would ultimately give me something that resembled the following
target_column | times_used |
---|---|
123.png | 40 |
abc.png | 30 |
xyz.jpg | 20 |