Mysql: how to generate count table by PATTERN / LIKE statement ? very tricky
- by Abdulrahman Al-Qabandi
to simplify, I got a database of registered users, I want to count how many emails there are for each email domain name (note I do not know all domain names)
for example,
Users table-
id | email
------------------
1 | test@hotmail.com
2 | test@somesite.aaa<--unknown to me
3 | test@unknownsite.aaa<--unknown to me
4 |…