Treehouse | Community | Replacing Strings

🤑 Join the Treehouse affiliate program and earn 25% commission!

Join our Live Career-Building Workshop: Fast-Track Your Tech Career Without a Degree! ⭐ Register here!

🌟 Dreaming of a bright future? 🎓 Ask about the Treehouse Scholarship program! 🚀

Curious which AI tools Treehouse developers love? ⚙️ Check them out!

🫡 Treehouse for Military offers discounts to Veterans, service members and their families!

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Talon Ward
2,495 Points
SELECT REPLACE(email, "@" "<at>") AS "obfuscated_email" FROM customers; What am I missing here?

Posted October 9, 2020 12:00am by Talon Ward

Talon Ward
2,495 Points
1 Answer
Lucio Bonforte
4,164 Points
I need help please. What am I doing wrong?

Posted October 8, 2020 3:11pm by Lucio Bonforte

Lucio Bonforte
4,164 Points
2 Answers
PLUS

Jordan young
Courses Plus Student 5,277 Points
Alias in Concatenation Reporting

Posted September 16, 2020 3:05am by Jordan young

Jordan young
Courses Plus Student 5,277 Points
1 Answer
Monika Biela
3,370 Points
Bummer messages

Posted September 10, 2020 12:24pm by Monika Biela

Monika Biela
3,370 Points
1 Answer
Tom Weaver
2,342 Points
I can't get my head around the aliasing here.

Posted September 3, 2020 3:13pm by Tom Weaver

Tom Weaver
2,342 Points
1 Answer
devis
4,059 Points
Where are the solutions for the workspace practice sessions of each of the 4 chapters of the course?

Posted August 21, 2020 10:39am by devis

devis
4,059 Points
0 Answers
theteamtreehouse
3,472 Points
I don't get why this is wrong

Posted August 21, 2020 12:24am by theteamtreehouse

theteamtreehouse
3,472 Points
1 Answer
theteamtreehouse
3,472 Points
Why wouldn't this also work?

Posted August 20, 2020 10:55pm by theteamtreehouse

theteamtreehouse
3,472 Points
1 Answer
theteamtreehouse
3,472 Points
This test case only supports "operator ||", but it did not specify that it only supports SQLite syntax. I used CONCAT().

Posted August 20, 2020 4:15pm by theteamtreehouse

theteamtreehouse
3,472 Points
0 Answers
Ash Mitchell
6,034 Points
Why do we not use 'SELECT FROM' in this query case?

Posted August 13, 2020 12:31pm by Ash Mitchell

Ash Mitchell
6,034 Points
1 Answer
Adam Hughes
1,259 Points
Getting Max Length with title

Posted August 11, 2020 1:28pm by Adam Hughes

Adam Hughes
1,259 Points
1 Answer
Justin Young
7,015 Points
SELECT first_name || " " || last_name || " " || <email> AS "to_field" FROM patrons; [SOLVED]

Posted August 4, 2020 9:20pm by Justin Young

Justin Young
7,015 Points
1 Answer
aditya verma
1,853 Points
Please improve the quality of questions, the period at the end of the text, is it part of the output or not?!

Posted August 2, 2020 11:06am by aditya verma

aditya verma
1,853 Points
2 Answers
aditya verma
1,853 Points
Don't know whats wrong

Posted August 2, 2020 10:58am by aditya verma

aditya verma
1,853 Points
1 Answer
aditya verma
1,853 Points
Cannot identify the mistake

Posted August 2, 2020 10:55am by aditya verma

aditya verma
1,853 Points
1 Answer
aditya verma
1,853 Points
Mistake in code

Posted August 2, 2020 5:58am by aditya verma

aditya verma
1,853 Points
1 Answer
Todd Hamblen
4,523 Points
What type system is this supposed to be ran on?

Posted July 20, 2020 4:36pm by Todd Hamblen

Todd Hamblen
4,523 Points
1 Answer
sherelle smith
1,387 Points
SELECT * FROM books WHERE genre LIKE "%Fantasy" ORDER BY first_published LIMIT 5 ASC;

Posted July 19, 2020 5:57pm by sherelle smith

sherelle smith
1,387 Points
2 Answers
Alexander Vasin
7,938 Points
Bummer: Expected results to look like "Andrew CHALKLEY", "MCL1001" not "Andrew CHALKLEY", "MCL1001". Looks like the same

Posted July 17, 2020 4:53pm by Alexander Vasin

Alexander Vasin
7,938 Points
1 Answer
PLUS

mohammad almotairy
Courses Plus Student 606 Points
I did not understand the question Write the SQL query to retrieve the 3rd page of results

Posted July 9, 2020 12:23pm by mohammad almotairy

mohammad almotairy
Courses Plus Student 606 Points
1 Answer
Timmy Welch
1,599 Points
Getting same result as expected but not being allowed past the question.

Posted July 4, 2020 3:27pm by Timmy Welch

Timmy Welch
1,599 Points
1 Answer
Ariadna Rodriguez
6,281 Points
I don't understand where I should SELECT a new column and where I should concatenate the new output

Posted July 4, 2020 9:39am by Ariadna Rodriguez

Ariadna Rodriguez
6,281 Points
1 Answer
Matt Fuller
2,395 Points
Is Order Count w/ Date Challenge Still Flawed?

Posted July 3, 2020 5:53pm by Matt Fuller

Matt Fuller
2,395 Points
1 Answer
Tom Holliday
2,868 Points
I don't understand how we are supposed to know what the correct email formatting is. Are we supposed to add the < signs?

Posted July 1, 2020 1:36pm by Tom Holliday

Tom Holliday
2,868 Points
1 Answer
Ariadna Rodriguez
6,281 Points
should both columns be a substrings?

Posted July 1, 2020 4:14am by Ariadna Rodriguez

Ariadna Rodriguez
6,281 Points
1 Answer
Ariadna Rodriguez
6,281 Points
Should I be adding a space in between the commas also is that why my query is incorrect?

Posted June 29, 2020 1:03am by Ariadna Rodriguez

Ariadna Rodriguez
6,281 Points
1 Answer
Milind Sharma
2,656 Points
Why am i getting extra . at the end the select statement?

Posted June 17, 2020 4:40pm by Milind Sharma

Milind Sharma
2,656 Points
1 Answer
Derek Morse
1,776 Points
stuck

Posted May 27, 2020 3:04pm by Derek Morse

Derek Morse
1,776 Points
1 Answer
Derek Morse
1,776 Points
NOT understanding

Posted May 26, 2020 6:39pm by Derek Morse

Derek Morse
1,776 Points
2 Answers
Derek Morse
1,776 Points
help with details; please break down what i am missing

Posted May 26, 2020 2:30pm by Derek Morse

Derek Morse
1,776 Points
1 Answer

Prev Page 5 of 18 Next

Posting to the forum is only allowed for members with active accounts.
Please sign in or sign up to post.