select substring_index('somebody@somewhere.com', '@', 1);

SELECT SUBSTRING_INDEX(email, '@', 1) AS emailname FROM table;