TalkPHP - View Single Post

Salathe · 01-11-2008, 09:38 PM

My version of MySQL (5.0.27) allows me to make the following query without any complaints:

SQL Code:

SELECT DISTINCT 
    SUBSTRING(email, LOCATE('@', email) + 1) AS domain,
    COUNT(*) AS domain_count
FROM 
    users
GROUP BY 
    domain
ORDER BY 
    domain

01-11-2008, 09:38 PM	#5 (permalink)
Salathe Moderateur Join Date: Apr 2007 Posts: 1,393 Thanks: 5	My version of MySQL (5.0.27) allows me to make the following query without any complaints: SQL Code: SELECT DISTINCT SUBSTRING(email, LOCATE('@', email) + 1) AS domain, COUNT(*) AS domain_count FROM users GROUP BY domain ORDER BY domain