1517. Find Users With Valid E-Mails | SQL |

Опубликовано: 02 Июнь 2025
на канале: SheCodes

113

🎯 SQL Lovers, let's level up! 🎯

In this video, we’re diving deep into a super handy problem – finding users with valid emails in the wild world of databases! We're solving LeetCode SQL Problem 1517 using one of SQL’s hidden gems: Regular Expressions (REGEXP)! 💻✨

⚡ What’s the Challenge?
We’ve got a Users table filled with names and emails, but not all of them follow the rules. Your mission (if you choose to accept it 😉) is to spot the valid ones. Here's what makes an email valid:

📧 The prefix (before the @) must start with a letter and can include letters, numbers, underscores, periods, or dashes.
📧 The domain must be @leetcode.com — no freeloaders like Gmail or Yahoo here!
🧑‍💻 Example Time:
Winston’s email, [email protected] – boom, valid! ✅
Shapiro’s [email protected] – Uh-oh, starts with a dot! ❌
David’s [email protected] – Gmail? Not on this watch! ❌
We’ll use SQL's REGEXP magic to slice through the noise and grab the legit ones! 🪄✨

🚀 Why Watch?
Unlock the power of REGEXP to validate patterns in your SQL queries.
Learn how to filter tricky email formats with precision.
Get hands-on with a fun, practical challenge to flex your SQL skills.
If you've ever wanted to be the boss of data validation or just love solving real-world coding problems, this video is perfect for you! 😎💥

🔗 LeetCode Problem: https://leetcode.com/problems/find-us...

Don't forget to hit the like button and subscribe to join me on this coding adventure! Let’s crack SQL together like pros! 💡

#SQLMastery #EmailValidation #REGEXPSQL #LeetCodeChallenge #CodingForFun #DataNinja #SheCodes #TechJourney #GeekOut