How to find the same data in certain fields

Question

As the title states, I want to query only the duplicate data in a certain field of the database. How to query? Or how to do it with PHP?

As shown below, Zhang**’s name, phone number, province, city, etc. are all listed in the same way. There may be multiple records for Zhang San

Answer 1

select count(id) from table name group by recipient having count(id)>1

Answer 2

like query