-
Notifications
You must be signed in to change notification settings - Fork 4
Find Users #44
Answered
by
iamAntimPal
IamShiwangi
asked this question in
Q&A
Find Users
#44
-
1517. Find Users With Valid E-Mails
Wrong Answer
24 / 26 testcases passed
Editorial
Input
Users =
| user_id | name | mail |
| ------- | ------- | -------------------- |
| 1 | Winston | winston@leetcode?com |
Use Testcase
Output
| user_id | name | mail |
| ------- | ------- | -------------------- |
| 1 | Winston | winston@leetcode?com |
Expected
| user_id | name | mail |
| ------- | ---- | ---- |
This doesn't support visualization.
THIS IS SHOWING ME GIVE ME ANSWER
Beta Was this translation helpful? Give feedback.
All reactions
Answered by
iamAntimPal
Mar 22, 2025
SELECT *
FROM Users
WHERE REGEXP_LIKE(mail, '^[A-Za-z]+[A-Za-z0-9\_\.\-]*@leetcode\\.com$');
Replies: 1 comment 1 reply
-
SELECT *
FROM Users
WHERE REGEXP_LIKE(mail, '^[A-Za-z]+[A-Za-z0-9\_\.\-]*@leetcode\\.com$');
Beta Was this translation helpful? Give feedback.
All reactions
1 reply
-
Thnk you
Beta Was this translation helpful? Give feedback.
All reactions
Answer selected by
IamShiwangi
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment