How can i count the emaiid in my table

[sang]

Hi
I had a table with the Emailid, i want to count the particular domain in the Field Emailid.

For Example

Table User_account;
 
Emailid   Id
[e-mail] 1
[e-mail]   2
[e-mail]  3
 
 

I want to count domains

Emailid       count
yahoo.com    2
rediff.com      1
 

Please give me the query to count that

Thanks in advance
Sang

[ScarletPimpernal]

Hi,

Its so simple,try this query

SELECT Emailid,COUNT(Emailid) FROM User_account GROUP BY Emailid;

Thanks,
Scarlet

Hi
I had a table with the Emailid, i want to count the particular domain in the Field Emailid.

For Example

Table User_account;
 
Emailid   Id
[e-mail] 1
[e-mail]   2
[e-mail]  3
 
 

I want to count domains

Emailid       count
yahoo.com    2
rediff.com      1
 

Please give me the query to count that

Thanks in advance
Sang

[sang]

Hi,

Its so simple,try this query

SELECT Emailid,COUNT(Emailid) FROM User_account GROUP BY Emailid;

Thanks,
Scarlet

This is already i done. but i want to print the count of domain names. i done that also (ie)

 Select substring_index(emailid,'@',-1)as domain,count(Emailid) from User_
account group by domain;
 

Thank you for your reply
Sang