Treehouse | Community | String Functions

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

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
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
Paul Mefford
2,966 Points
Last Challenge Question

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

Paul Mefford
2,966 Points
1 Answer
MUZ140264 Tsitsi Mupamombe
4,195 Points
TROUBLE ON CHALLENGE 3

Posted June 25, 2015 12:31pm by MUZ140264 Tsitsi Mupamombe

MUZ140264 Tsitsi Mupamombe
4,195 Points
1 Answer
MUZ140610 Tinashe Marunda
7,028 Points
Select the "first_name" followed by the username in parentheses and alias it as "display_name". For example "Andrew (cha

Posted June 18, 2015 2:38am by MUZ140610 Tinashe Marunda

MUZ140610 Tinashe Marunda
7,028 Points
0 Answers
Samuel Sanders
6,992 Points
Why are these not working for Challenge #2

Posted June 4, 2015 8:08pm by Samuel Sanders

Samuel Sanders
6,992 Points
1 Answer
Juliette Tworsey
Front End Web Development Techdegree Graduate 32,628 Points
Select the first letter of the "first_name", add a period after it, followed by a space and add the "last_name".

Posted May 29, 2015 7:18pm by Juliette Tworsey

Juliette Tworsey
Front End Web Development Techdegree Graduate 32,628 Points
0 Answers
Becca Ades
4,205 Points
Don't understand why my code isn't working: SELECT CONCAT(first_name," ",(username)) AS display_name FROM users;

Posted May 22, 2015 10:27pm by Becca Ades

Becca Ades
4,205 Points
1 Answer
Pedro nieto Sanchez
28,169 Points
Help with this query please.

Posted May 18, 2015 10:40pm by Pedro nieto Sanchez

Pedro nieto Sanchez
28,169 Points
0 Answers
Pedro nieto Sanchez
28,169 Points
Could anyone help me with this Mysql query? I am using the Concat function.

Posted May 17, 2015 5:40pm by Pedro nieto Sanchez

Pedro nieto Sanchez
28,169 Points
0 Answers
Andrew VanVoorhis
7,760 Points
String Functions Challenge Task 2

Posted May 17, 2015 6:57am by Andrew VanVoorhis

Andrew VanVoorhis
7,760 Points
1 Answer
Daniele Vicinanzo
21,277 Points
Challenge Task 1 of 3 In the "users" table, lowercase the "email" column and alias it as "lower_email".

Posted May 16, 2015 12:30pm by Daniele Vicinanzo

Daniele Vicinanzo
21,277 Points
2 Answers
Pedro nieto Sanchez
28,169 Points
What am I doing wrong in this Concat query? Thanks

Posted May 15, 2015 7:08pm by Pedro nieto Sanchez

Pedro nieto Sanchez
28,169 Points
0 Answers
Matthew Fenton
6,331 Points
objective 2 of 3 in database foundations.

Posted May 5, 2015 11:17pm by Matthew Fenton

Matthew Fenton
6,331 Points
2 Answers

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

Daniel Sibanda

Daniel Sibanda

Daniel Sibanda

Daniel Sibanda

Junichi Shibatani

Junichi Shibatani

JoAnna Howell

JoAnna Howell

Paul Mefford

Paul Mefford

MUZ140264 Tsitsi Mupamombe

MUZ140264 Tsitsi Mupamombe

MUZ140610 Tinashe Marunda

MUZ140610 Tinashe Marunda

Samuel Sanders

Samuel Sanders

Juliette Tworsey

Juliette Tworsey

Becca Ades

Becca Ades

Pedro nieto Sanchez

Pedro nieto Sanchez

Pedro nieto Sanchez

Pedro nieto Sanchez

Andrew VanVoorhis

Andrew VanVoorhis

Daniele Vicinanzo

Daniele Vicinanzo

Pedro nieto Sanchez

Pedro nieto Sanchez

Matthew Fenton

Matthew Fenton