Incorrect SQL solution for Problem 1517 (Find Users With Valid E-Mails)

[piyushlasane]

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';

[HARIHARANS24]

SELECT *
FROM Users
WHERE
mail REGEXP '^[a-zA-Z][a-zA-Z0-9_.-]*@leetcode\.com$'
AND BINARY mail LIKE '%@leetcode.com';

[yanglbme]

Hi @piyushlasane @HARIHARANS24

Thanks for your feedback. I've fixed the incorrect SQL solution :)