SELECT substring_index(email, '@', -1) domain, COUNT(*) email_count FROM table GROUP BY substring_index(email, '@', -1) -- If you want to sort as well: ORDER BY email_count DESC, domain;