Databases Reporting with SQL Working with Text Replacing Strings

Karen Shumate
Karen Shumate
13,570 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

KRIS NIKOLAISEN
PRO
KRIS NIKOLAISEN
Pro Student 44,759 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;