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

11 votes221 views3 answers
How to get last row of table in sql
SQL
5 votes215 views1 answer
Get column name sql server
SQL
1 vote209 views1 answer
Date_part mysql
SQL
0 vote198 views1 answer
Mysql find db contarint
SQL
0 vote215 views1 answer
Hex string sql becomes int64
SQL
1 vote201 views1 answer
Oracle lock user
SQL
0 vote220 views1 answer
How to get first 10 records of a table in mysql
SQL
-1 vote230 views1 answer
How to Activate the database
SQL
0 vote178 views1 answer
Mariadb list tables
SQL
0 vote207 views1 answer
Mysql query to check record exists in database table or not
SQL