Pattern Matching with LIKE

Wildcards

• % matches any sequence of characters
• _ matches exactly one character

Examples

LIKE '%@%.%'     -- basic email pattern
LIKE '555%'      -- starts with 555
LIKE '%gmail.com'-- ends with gmail.com

Your Task

Find leads with potentially invalid emails:

• Show: id, first_name, email
• Find emails that DON'T contain '@' or don't have a '.' after the '@'
• Use NOT LIKE with the pattern '%@%.%'
• Exclude NULL emails
• Order by id