How can I check for duplicate user accounts using SQL? The back office is not robust enough to show me what I want and I shouldn't really need to get a plugin to do this.

I just want to check to see if there are accounts with the same email address.

Magento (Yes I know it's old but I cannot upgrade due to contractor making core mods)

2 Answers 2


Magento save customer data at table customer_entity in DB and here magento is save customer email also.

customer_entity table mail table for Mage::getModel('customer/customer') models.

If you want to check mail address already exit in system then try below Query

SELECT , COUNT() c FROM customer_entity GROUP BY email HAVING c > 1

  • not selecting a single email address. want to find ANY duplicates.
    – MB34
    Jul 7, 2015 at 15:10
  • update..plz now..
    – Amit Bera
    Jul 7, 2015 at 15:16
  • 1
    Simpler: SELECT *, COUNT(*) c FROM customer_entity GROUP BY email HAVING c > 1
    – MB34
    Jul 7, 2015 at 15:23
  count(entity_id) counter,
FROM customer_entity
GROUP BY email, store_id
HAVING counter > 1;

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.