Treehouse | Community | String Functions

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

🌟 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

Jeff Styles
2,784 Points
Using LENGTH function as a condition without issuing an alias or displaying its value in output...

Posted February 2, 2017 7:22pm by Jeff Styles

Jeff Styles
2,784 Points
0 Answers
Daniel Sokol
14,888 Points
Not quite getting "Group By".........

Posted September 10, 2016 2:42pm by Daniel Sokol

Daniel Sokol
14,888 Points
2 Answers
James Miller
7,661 Points
New Version of MYSQL prevents me from following video.

Posted September 8, 2016 8:36am by James Miller

James Miller
7,661 Points
0 Answers
Sebas Pinto
462 Points
What benefit has manipulate Strings directly in the query and not in the Programming Language that i'm using for my app?

Posted September 8, 2016 12:09am by Sebas Pinto

Sebas Pinto
462 Points
1 Answer
Manav Misra
11,778 Points
Why does average rating of Alien show differently on later queries?

Posted August 4, 2016 1:10am by Manav Misra

Manav Misra
11,778 Points
1 Answer
Javid Abbasov
9,243 Points
Please, HEEELP!!!!

Posted April 3, 2016 6:43pm by Javid Abbasov

Javid Abbasov
9,243 Points
3 Answers
Telmo Teixeira
16,378 Points
Error Code: 1055 "...sql_mode=only_full_group_by"

Posted March 2, 2016 11:57am by Telmo Teixeira

Telmo Teixeira
16,378 Points
4 Answers
Sean Flanagan
33,235 Points
Teacher's Notes

Posted January 12, 2016 11:23pm by Sean Flanagan

Sean Flanagan
33,235 Points
1 Answer
Sean Flanagan
33,235 Points
IFNULL

Posted January 12, 2016 2:55pm by Sean Flanagan

Sean Flanagan
33,235 Points
2 Answers
Sean Flanagan
33,235 Points
Can't import treehouse_movie_db

Posted January 7, 2016 12:53pm by Sean Flanagan

Sean Flanagan
33,235 Points
5 Answers
Elena Paraschiv
9,938 Points
LEFT OUTERJOIN AND LEFT JOIN

Posted November 15, 2015 11:38pm by Elena Paraschiv

Elena Paraschiv
9,938 Points
1 Answer
michaelmugo
3,971 Points
I don't understand the combination of JOIN and GROUP BY

Posted October 16, 2015 2:23pm by michaelmugo

michaelmugo
3,971 Points
1 Answer
Mayank Sapra
4,555 Points
Unable to access the links suggested in teacher's notes for further reading ?

Posted October 3, 2015 10:49am by Mayank Sapra

Mayank Sapra
4,555 Points
1 Answer
MUZ1407800 Doubt Milazi
11,813 Points
help me guys

Posted September 30, 2015 1:42pm by MUZ1407800 Doubt Milazi

MUZ1407800 Doubt Milazi
11,813 Points
1 Answer
Tomas Svojanovsky
26,680 Points
imported sql into XAMPP and did query -> found rows, but here get error message about OUTER JOIN

Posted September 16, 2015 5:36am by Tomas Svojanovsky

Tomas Svojanovsky
26,680 Points
1 Answer
Lucas Hoelscher
3,647 Points
Don't understand the syntax for these quesitons

Posted September 8, 2015 7:51pm by Lucas Hoelscher

Lucas Hoelscher
3,647 Points
1 Answer
Daniel Schwemmlein
4,960 Points
grouping joining and cleaning up challenge 3rd task

Posted August 30, 2015 5:45pm by Daniel Schwemmlein

Daniel Schwemmlein
4,960 Points
1 Answer
gretacipriano
1,341 Points
Problem with the 3rd challenge.

Posted August 22, 2015 2:24pm by gretacipriano

gretacipriano
1,341 Points
1 Answer
Adam Zuckerberg
22,248 Points
HAVING can use an alias?

Posted August 20, 2015 7:27pm by Adam Zuckerberg

Adam Zuckerberg
22,248 Points
1 Answer
Ricardo Vargas
3,583 Points
Using functions better practices question

Posted August 8, 2015 7:58pm by Ricardo Vargas

Ricardo Vargas
3,583 Points
1 Answer
Daniel Sibanda
4,803 Points
Select the first letter of the "first_name", add a period after it, followed by a space and add the "last_name". Also, c

Posted August 6, 2015 11:05am by Daniel Sibanda

Daniel Sibanda
4,803 Points
2 Answers
Daniel Sibanda
4,803 Points
Select the "first_name" followed by the username in parentheses and alias it as "display_name". For example "Andrew (cha

Posted August 6, 2015 9:54am by Daniel Sibanda

Daniel Sibanda
4,803 Points
1 Answer
MUZ141094 Smart Mashegede
3,335 Points
"Group all reviews by "movie_id" and get the average "score" and alias it as "average"

Posted July 29, 2015 12:42pm by MUZ141094 Smart Mashegede

MUZ141094 Smart Mashegede
3,335 Points
3 Answers
Junichi Shibatani
651 Points
CONCAT question

Posted July 27, 2015 8:38pm by Junichi Shibatani

Junichi Shibatani
651 Points
1 Answer
JoAnna Howell
7,191 Points
Unknown column 'first_name' in 'field list'

Posted July 18, 2015 11:29pm by JoAnna Howell

JoAnna Howell
7,191 Points
1 Answer
Darren Joy
19,573 Points
DB Foundations Grouping Joining and Cleaning Up Challenge

Posted July 14, 2015 4:49pm by Darren Joy

Darren Joy
19,573 Points
2 Answers
efi domb
9,569 Points
Grouping, Joining and Cleaning Up

Posted July 13, 2015 3:42pm by efi domb

efi domb
9,569 Points
1 Answer
Grant Iverson
3,520 Points
Where is the updated database?

Posted June 30, 2015 6:03pm by Grant Iverson

Grant Iverson
3,520 Points
0 Answers
Leigh Maher
21,830 Points
Where does the word 'average' come from?

Posted June 29, 2015 9:26am by Leigh Maher

Leigh Maher
21,830 Points
0 Answers
Paul Mefford
2,966 Points
Last Challenge Question

Posted June 27, 2015 6:50pm by Paul Mefford

Paul Mefford
2,966 Points
1 Answer

Prev Page 1 of 4 Next

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