Which Email Providers are the Most Popular?

February 9th, 2010 Leave a comment Go to comments

At Mango's day job, he operates a mailing list for his customers.  Approximately 2,000 customers have subscribed to it.  He wanted to set up test email accounts with various webmail providers to be sure his emails arrived as intended.  But which webmail providers should he choose?  The most popular email providers were easily found with this MySQL query:
SELECT
SUBSTRING(`email`, LOCATE('@', `email`)) AS `domain`,
COUNT(*) AS `count`
FROM `table`
GROUP BY `domain`
ORDER BY `count` DESC
For our list, the results were:

Major regional ISPs - 39%
Hotmail - 14%
Yahoo - 9%
Gmail - 8%
AOL - 1%

The remaining 29% consisted of small ISPs and insignificant webmail providers, each less than 1% of the total.
 

If you would like a reply to your comment, you must leave your email address! We receive dozens of questions every month from people who don't leave us with any way to contact them, so we have no choice but to ignore the question. We try to reply to as many questions as we can, if we know the email address of the person who asked the question. Thanks in advance for writing in :)

Allowed HTML: <b>, <i>, <em>, <strong>. All other < and > will be replaced with &lt; and &gt;.