Select domain name and username from email with MySQL

To select domain part of the email address:

SELECT SUBSTRING(email, LOCATE('@', email) + 1) AS domain FROM users;

Where email is field with email address and users is database table.

To select username or local part of email address:

SELECT SUBSTRING(email, 1, LOCATE('@', email) - 1) AS username FROM users;