· 9 years ago · Oct 30, 2016, 03:46 PM
1SELECT (SUBSTR(`email`, INSTR(`email`, '@') + 1, LENGTH(`email`))) AS 'dominios_repetidos'
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