Query for duplicate records

[email protected] ("Ron Piggott")
Newsgroups php.db
Message-ID <E779617E83A84C6B8357E6D945E36798@RonPiggottPC>
Is there a query you could help me write a SELECT query that would search table `ministry_profiles` for where column `organization`  has the same organization more than once?  I am trying to delete the duplicate organization records, but I am working with 1,000+ businesses and I can't go through each record looking for duplicates.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.