Databases Reporting with SQL Working with Text Replacing Strings

Troy Erby
Troy Erby
6,332 Points

Having trouble with Reporting SQL with the REPLACE function

I've read many of the posts concerning this but I'm still at a loss. I've tried a few versions but this is my latest:

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

Charlie Harcourt
Charlie Harcourt
8,037 Points

Hi! Great question :)

You don't need the 'email' after the select you're trying to select it twice.

Hope that made sense! (correct me if i'm wrong anyone)

The code below is a spoiler!!! Good luck :)

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

1 Answer

Charlie Harcourt
Charlie Harcourt
8,037 Points

Hi! Great question :)

You don't need the 'email' after the select you're trying to select it twice.

Hope that made sense! (correct me if i'm wrong anyone)

The code below is a spoiler!!! Good luck :)

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

Troy Erby
Troy Erby
6,332 Points

That was the magic solution. It wasn't clear to me from other posts that using the REPLACE function with 'email' inside eliminated the need to state 'email' separately. Thanks.