Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trialSachin Parkash
2,590 Pointsreplacing strings of text task 1
I dont know how I am wrong with this
SELECT email AS "obfuscated_email" FROM customers WHERE REPLACE(email, "@", "<at>");
it still says bummer: try again. No real help at all.
1 Answer
Bramyn Payne
19,589 PointsHi Sachin,
First, I don't believe that you need a WHERE
statement since you aren't looking for any specific conditions to be met.
Second, the REPLACE
statement doesn't go at the end. You use it where you are using email
. You don't actually need to have email
at the beginning since it is in your REPLACE
statement.
Hope that helps and good luck!
Sachin Parkash
2,590 PointsSachin Parkash
2,590 PointsThanks so much Bramyn. This helped a lot!