Grouping by email domain mysql

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;

Source: stackoverflow.com

Similar codes

0 vote137 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
0 vote137 views1 answer
Oracle synonym procedure dblink
SQL
0 vote129 views1 answer
Restore backupfile discourse
SQL
1 vote139 views1 answer
Oracle sql average
SQL
0 vote133 views1 answer
Postgresql extract hour and minutes from timestamp
SQL
0 vote129 views1 answer
Mysql where don't have string
SQL
0 vote138 views1 answer
Oracle session statistics
SQL
0 vote162 views1 answer
Mariadb hours between two dates
SQL
0 vote123 views1 answer
Clone table structure mysql
SQL
0 vote157 views1 answer
Select all same column value in sql
SQL