Databases Reporting with SQL Working with Text Replacing Strings

Karen Shumate
Karen Shumate
13,579 Points

Write a query that will retrieve all email addresses but will replace the @ symbol with <at> so they all look like andre

Lately when I put a question in it takes out my code can someone check Treehouse to see if it is working correctly.

SELECT REPLACE(email, "@", "<at>") AS "obfuscated _email" FROM customers;

In case it did not post this time.

1 Answer

Pro Student 51,912 Points

You are very close but you have a space between obfuscated and _email. Remove that and you will pass.

SELECT REPLACE(email, "@", "<at>") AS "obfuscated_email" FROM customers;