I'd like to get a better idea of what domains my customers are using. I could easily do this in PHP by explode
ing each address and counting the domain that way. But I'm wondering if there's a way to get this information with just a plain MySQL query?
This is what sample output would look like:
gmail.com | 3942
yahoo.com | 3852
hotmail.com | 209
... and so on, where the first column is the email addresses domain, and the 2nd column is the number of addresses at that domain.