Need help with a query. How to search for emails with all lowercase letters, no periods, and no numbers Here's my query:
Posted: Mon Mar 21, 2022 4:40 pm
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]','%.%'')
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]','%.%'')