Closed
Description
Hi,
The SQL solution for 1517. Find Users With Valid E-Mails is incorrect.
Problem:
The current query does not enforce case sensitivity for the domain "leetcode.com".
Correct SQL:
SELECT *
FROM Users
WHERE
mail REGEXP '^[a-zA-Z][a-zA-Z0-9_.-]*@leetcode\\.com$'
AND BINARY mail LIKE '%@leetcode.com';Metadata
Metadata
Assignees
Labels
No labels
Type
Projects
Milestone
Relationships
Participants
Activity
HARIHARANS24 commentedon Jun 15, 2025
SELECT *
FROM Users
WHERE
mail REGEXP '^[a-zA-Z][a-zA-Z0-9_.-]*@leetcode\.com$'
AND BINARY mail LIKE '%@leetcode.com';
fix: correct case-sensitivity issue in lc problem No.1517 (#4495)
yanglbme commentedon Jun 15, 2025
Hi @piyushlasane @HARIHARANS24
Thanks for your feedback. I've fixed the incorrect SQL solution :)