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

1 Expert Approved Answer
Step: 1 Unlock

To solve this problem using SQL with regular expressions we can utilize the REGEXPEXTRACT function i... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!