Find Users With Valid E-Mails - LeetCode

PHOTO EMBED

Fri Sep 29 2023 17:31:04 GMT+0000 (Coordinated Universal Time)

Saved by @jaez #mysql

#Find emails: they that MUST start with a letter and MUST BE FOR LEETCODE.COM. 
#Emails can contain letters, numbers, underscores, periods, dashes and hyphens.

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

https://leetcode.com/problems/big-countries/?envType