to simplify,
I got a database of registered users,
I want to count how many emails there are for each email domain name (note
I do not know all domain names)
for example,
Users table-
id | email
------------------
1 |
[email protected]
2 |
[email protected]<--unknown to me
3 |
[email protected]<--unknown to me
4 |
[email protected]
5 |
[email protected]<--unknown to me
6 |
[email protected]
7 |
[email protected]
8 |
[email protected]
( note:
I want to count each email without specifying which email exactly )
so the result
I want is
suffix | count
hotmail.com | 3
somesite.aaa | 2
unknownsite.aaa| 1
yahoo.com | 2
again,
I stress this,
I do not know unknownsite.aaa nor can
i mention it in a statement because it is unknown to me,
i hope I am clear.
So essentially
I want to make a statistic of what my website users use as an email host website.
but like
I said and
I will repeat the third time,
I do not know every mailhost that exists.
I am going to investigate this more,
I have a feeling this is something mysql cannot handle.