MYSQL REGEXP_LIKE
The first matcher is for the first half. the second, the second half. The last is for no duplicate @ symbols.Code
The first matcher is for the first half. the second, the second half. The last is for no duplicate @ symbols.
# Code
```mysql []
SELECT *
FROM Users
WHERE 
    regexp_like(email, '^[a-zA-Z0-9]+@')
    AND regexp_like(email, '@[a-zA-Z].*\\.com$')
    and NOT regexp_like(email, '.*@.*@.*')
ORDER BY user_id ASC
```
['MySQL']