Valid Email Addresses
Medium
String Validation & Regex
Return the ids of users whose email address is valid: letters, digits or . _ % + - before the @, then a domain with at least one dot and a final part of two or more letters. Order by id.
Table schema
Users(id INT PRIMARY KEY, email VARCHAR(100))Sample data
id | email
1 | a@x.com
2 | bad@
3 | @x.com
4 | c.d@y.co.in
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.