count domain users using sql — sql — codestacker

you are in: codestacker → codes [RSS] → count domain users using sql

count domain users using sql

from: http://www.mendable.com/sql-trick-where-are-your-users-from/

show/hide lines

   1  SELECT COUNT(*) AS Total, SUBSTRING_INDEX(email, '@', -1) AS Domain FROM users 
   2  GROUP BY SUBSTRING_INDEX(email, '@', -1) ORDER BY COUNT(*) DESC LIMIT 10;

SELECT COUNT(*) AS Total, SUBSTRING_INDEX(email, '@', -1) AS Domain FROM users 
GROUP BY SUBSTRING_INDEX(email, '@', -1) ORDER BY COUNT(*) DESC LIMIT 10;

created by leozera — 12 July 2009 — get a short url — tags: mysql sql — embed

Comments