Mi falla sorry:
Código SQL:
Ver originalSELECT completo FROM(
SELECT SUBSTRING(correo,1,INSTR(correo,'.')+1) AS completo FROM(
SELECT SUBSTRING(email, INSTR(email,'@')+-, lenght(email)) AS correo FROM tabla
) AS t1
) AS t2 WHERE completo='outlook' LIMIT 2;
UNION ALL
SELECT completo FROM(
SELECT SUBSTRING(correo,1,INSTR(correo,'.')+1) AS completo FROM(
SELECT SUBSTRING(email, INSTR(email,'@')+-, lenght(email)) AS correo FROM tabla
) AS t1
) AS t2 WHERE completo<>'outlook' LIMIT 1;
Pruebalo de nuevo, el error era que en un union las columnas en los 2 queries deben de ser las mismas