How to find duplicates in MySQL?

Question

MySQL

Hello , how to do search and delete in MYSQL database? Through PHP?

Answer 1

We look for duplicates by grouping by value and filtering those that are less than two.
Example

SELECT
    valueField1,
    valueField2,
    count(*)
FROM
    myTable
GROUP BY
    valueField1,
    valueField2
HAVING
    count(*)>1

Be sure to include all relevant fields.
Delete on what basis? All but the first one you see?

Answer 2

The search for duplicates can be implemented with a regular SELECTquery, and the removal, respectively, with the help of DELETE.