Using REGEXP_LIKE
SELECT *
FROM Users
WHERE REGEXP_LIKE (email,'[a-zA-z0-9]+@[a-zA-Z]+.com')
ORDER BY user_id;

SELECT * 
FROM Users
WHERE REGEXP_LIKE (email,'[a-zA-z0-9]+@[a-zA-Z]+\.com')
ORDER BY user_id;

['PostgreSQL']