Monthly Archives: March 2013

MySQL query for obtaining unique list of domain names with count from email field

The following MySQL query is useful for getting a count of all the domain names used by email addresses in your database.  It isolates the domain name (after the @ sign) in the email field. SELECT substring_index(email, ‘@’, -1), COUNT(*) … Continue reading

Posted in Code, Data | Comments Off on MySQL query for obtaining unique list of domain names with count from email field