Find duplicate records in MySQL
So, the task is to get duplicate records from a MySQL database. The easy way: SELECT COUNT(*), column1, column2 FROM tablename GROUP BY column1, column2 HAVING COUNT(*)>1; More complex case: shows...
$
grep -r "#duplicate" ./posts
Tag
#duplicate
// 1 match