Other useful stuff.
Return no result or result.
SELECT 1 FROM table WHERE key = value;
Return zero or one.
SELECT COUNT(1) FROM table WHERE key = value;
SELECT SUBSTR(email, INSTR(email, '@') + 1) AS domain FROM table;