MySQL How to select domain name from email address ?

Posted on July 24, 2014July 24, 2014 by Благомир Иванов

SELECT 
   COUNT(*) as cnt, SUBSTR(SUBSTR(Email, INSTR(Email, '@'), INSTR(Email, '.')), 2) as domain 
FROM 
   Users 
GROUP BY domain 
ORDER BY cnt DESC

SELECT COUNT(*) as cnt, SUBSTR(SUBSTR(Email, INSTR(Email, '@'), INSTR(Email, '.')), 2) as domain FROM Users GROUP BY domain ORDER BY cnt DESC

Posted in How to ... ?, MySQL, Quick Tips

Previous: lost connection with while performing the HELO handshake

Next: List all subfolders in path

How to ... ?

Automatically create Bitbucket pull requests via API/cURL

Благомир Иванов
June 27, 2016

#!/bin/bash array=( folder1 repofolder2 another_repo_folder ) FROM=staging TO=master for i in "${array[@]}" […]

How to ... ?
Scripts

Elasticsearch 101

Благомир Иванов
January 8, 2014

Един от най-добрите tutorials, които до сега съм намерил за Elasticsearch e http://joelabrahamsson.com/elasticsearch-101/

How to ... ?

Списък с всички симлинкове (symlinks) в папка… рекурсивно

Благомир Иванов
May 1, 2014

ls -lR /path/to/folder/ | grep ^lls -lR /path/to/folder/ | grep ^l

We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.Ok

Related Posts

Automatically create Bitbucket pull requests via API/cURL

Elasticsearch 101

Списък с всички симлинкове (symlinks) в папка… рекурсивно