2017-07-21 メールアドレスのドメイン毎に件数を集計する MySQL Operation select SUBSTRING(email,LOCATE('@',email)) as domain , count(*) as count from user group by domain;