Need help with a query. How to search for emails with all
lowercase letters, no periods, and no numbers
Here's my query:
and regexp_like (split_part(email,'@',2), 'emaildomain')
and regexp_like (split_part(email,'@',1), '[a-z]')
and NOT regexp_like (split_part(email,'@',1), '[0-9]','%.%'')
Need help with a query. How to search for emails with all lowercase letters, no periods, and no numbers Here's my query:
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Need help with a query. How to search for emails with all lowercase letters, no periods, and no numbers Here's my query:
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!