· 9 years ago · Oct 30, 2016, 03:42 PM
1SELECT (SUBSTR(email, INSTR(email, '@') + 1, LENGTH(email)))
2FROM `tabla`
3WHERE `email` NOT LIKE '%@gmail.com' AND `email` NOT LIKE '%@hotmail.%' AND `email` NOT LIKE '%@outlook.%' AND `email` NOT LIKE '%@yahoo.%'
4GROUP BY `email`
5HAVING COUNT(*) > 1