Skip to content
This repository

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
tree: c3f19f8335
Fetching contributors…

Cannot retrieve contributors at this time

file 3 lines (3 sloc) 0.268 kb
1 2 3
-- find your most popular email domains from your user table
-- if table is called users and field is called email:
 SELECT substring_index(email, '@', -1), COUNT(*) as c FROM users where email != '' GROUP BY substring_index(email, '@', -1) ORDER BY c DESC limit 50;
Something went wrong with that request. Please try again.