Find Users With Valid E-Mails · iamAntimPal/LeetCode_SQL_Database · Discussion #43

Antim-IWP
Mar 21, 2025
Collaborator

Answered by iamAntimPal

SELECT *
FROM Users
WHERE REGEXP_LIKE(mail, '^[A-Za-z]+[A-Za-z0-9_.-]*@leetcode\.com$');

SELECT *
FROM Users
WHERE REGEXP_LIKE(mail, '^[A-Za-z]+[A-Za-z0-9_.-]*@leetcode\.com$');

0 replies

Answer selected by Antim-IWP