Posted by: scoopseven 16 years, 1 month 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) Share on Twitter Share on Facebook
Recent Tweets
-
@mashable
@Pete Cashmore
How unequal is wealth in the U.S.? @Charlie_White found this viral video that will astonish you: http://t.co/tgTKMoljnW11 years, 1 month ago -
@scoopseven
@Mark Kecko
"That pizza was great, but probably fattening as tarnation." @innerpeaceLMT @ccchiodo11 years, 1 month ago -
@scoopseven
@Mark Kecko
@MattioV You know it's bad when you're volunteering yourself for busy work. "I have some import statements to clean up, take me a few days."11 years, 1 month ago
Recent Posts
- Django: Unknown command: 'test'
- Granola
- Export Zinna - Import Mezzanine
- Apache Enable Directory Browsing (Indexes) in Arch Linux
- Python/Django Tips n' Tricks Cheatsheet
Archive
2013
2012
2011
2010
- December (1)
2009
2008
2007
2006
Categories
- Apache (5)
- Apple (2)
- ColdFusion (23)
- Database (3)
- Django (20)
- DNS (1)
- IIS (5)
- jQuery (1)
- Linux (13)
- Mac (1)
- MediaPost (14)
- MySQL (15)
- PHP (1)
- Python (10)
- Recipes (1)
- Sphinx (2)
- Tools (2)
- Windows (1)
- WordPress (4)
Authors
- scoopseven (81)