Question: Write a SELECT statement that uses regular expression functions to get the username and domain name parts of the email addresses in the Administrators table.
Write a SELECT statement that uses regular expression functions to get the username and domain name parts of the email addresses in the Administrators table. Return these columns: The email_address column A column named user_name that contains the username part of the email_address column (the part before the @ symbol) A column named domain_name that contains the domain name part of the email_address column (the part after the @ symbol)
Step by Step Solution
3.42 Rating (149 Votes )
There are 3 Steps involved in it
To solve this problem using SQL with regular expressions we can utilize the REGEXPEXTRACT function i... View full answer
Get step-by-step solutions from verified subject matter experts
