Finding Parsing Domain from Email in MySQL

Posted by: scoopseven 16 years ago

SELECT SUBSTRING_INDEX(Email, '@', -1), COUNT(SUBSTRING_INDEX(Email, '@', -1)) AS numDomain FROM TableName GROUP BY SUBSTRING_INDEX(Email, '@', -1) ORDER BY numDomain DESC, SUBSTRING_INDEX(Email, '@', -1)

Currently unrated


Recent Tweets

Recent Posts

Archive

2013
2012
2011
2010
2009
2008
2007
2006

Categories

Authors

Feeds

RSS / Atom