How to find duplicate rows based on multiple fields in MySQL? [duplicate]

December 18, 2023 by Tarik

Here is what you want

SELECT title, time  
  FROM table
GROUP BY title, time
  HAVING count(*) > 1