Databases Reporting with SQL Working with Text Replacing Strings

Mohd Aamir Mir
Mohd Aamir Mir
3,281 Points

select email from customers where REPLACE(email,"@","<at>") as obfuscated_email;

help with this one

1 Answer

Antonio Suria
Antonio Suria
3,711 Points

you are calling it twice and you should use the REPLACE() before the the FROM like this: select REPLACE(email,"@","<at>") as obfuscated_email from customers;