Leetcode Problem 1517. Find Users With Valid E-Mails

1517. Find Users With Valid E-Mails

Leetcode Solutions

Start the RegEx pattern with ^ to indicate the beginning of the string.
Use [a-zA-Z] to match the first character as a letter (either upper or lower case).
Follow with [a-zA-Z0-9_.-]* to match any subsequent characters that can be letters, digits, underscores, periods, or dashes, repeated zero or more times.
Escape the @ symbol with \@ as it is a special character in RegEx.
Specify the domain with leetcode\.com (escaping the period).
End the RegEx pattern with $ to indicate the end of the string.
Use the REGEXP operator in the SQL query to filter the emails based on the pattern.

erDiagram
    Users {
        int user_id
        varchar name
        varchar mail
    }

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen