Databases Reporting with SQL Working with Text Replacing Strings

Carol Garcia
Carol Garcia
1,875 Points

Second attempt.

Now I feel like I'm way off. Here's what I got:

SELECT REPLACE(email, '%@%', "<a>") FROM customers WHERE REPLACE(email, '%@%', "<a>") = "<a>";

1 Answer

Some hints with the following syntax for replace REPLACE(string,pattern,replacement):

  • pattern doesn't need wildcards
  • replacement is <at> not <a>
  • there is no WHERE condition needed
  • you are missing the obfuscated_email alias