Treehouse | Community | Searching Tables with 'WHERE'

Notice: Workspaces are undergoing maintenance and are temporarily unavailable.

🚀 In our NEW AI Bootcamp you'll build a working app in 28 days, no experience required. Free to all subscription levels.

✨ Earn college credits in Cybersecurity, JS, HTML, CSS and Python

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

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

PLUS

Jaqua Starr
Courses Plus Student 972 Points
It keeps saying there is something wrong with my statement, am I missing something?

Posted February 10, 2022 6:45pm by Jaqua Starr

Jaqua Starr
Courses Plus Student 972 Points
0 Answers
chris muhirwa
1,112 Points
need help answering the question

Posted September 2, 2021 4:48am by chris muhirwa

chris muhirwa
1,112 Points
0 Answers
Ricky Redman
7,520 Points
WHERE keyword

Posted July 8, 2021 5:36pm by Ricky Redman

Ricky Redman
7,520 Points
1 Answer
Jason Nutt
Front End Web Development Techdegree Graduate 24,851 Points
I'm not sure how I am writing this wrong...SELECT username FROM users WHERE last_name = "Chalkey";

Posted October 24, 2020 3:48pm by Jason Nutt

Jason Nutt
Front End Web Development Techdegree Graduate 24,851 Points
5 Answers
Leslie Whitford
714 Points
What am I doing wrong in my command?

Posted September 10, 2020 6:50pm by Leslie Whitford

Leslie Whitford
714 Points
1 Answer
Farfetch UK Spinetto
2,139 Points
Hello, I don't understand why my answer is incorrect

Posted April 16, 2020 8:42am by Farfetch UK Spinetto

Farfetch UK Spinetto
2,139 Points
0 Answers
Bas Spijker
353 Points
Hello. I got stuck with this database challenge. Could someone provide me the correct query?

Posted April 14, 2020 6:14pm by Bas Spijker

Bas Spijker
353 Points
2 Answers
Claire Uzenski
1,026 Points
How do i complete the equation

Posted January 16, 2020 2:24pm by Claire Uzenski

Claire Uzenski
1,026 Points
1 Answer
DCI Seven
828 Points
SELECT first_name, last_name, FROM users WHERE username = "wig_lady";

Posted December 3, 2019 10:00pm by DCI Seven

DCI Seven
828 Points
1 Answer
Sung-Fu Han
3,890 Points
why the query won't work in task 2 of 3? SELECT * FROM　products WHERE price != 9.99;

Posted August 29, 2019 9:27am by Sung-Fu Han

Sung-Fu Han
3,890 Points
2 Answers
Yusuf Balogun
1,829 Points
In our e-commerce database we have a users table with the columns id, username, password, first_name and last_name.

Posted August 17, 2019 11:24pm by Yusuf Balogun

Yusuf Balogun
1,829 Points
1 Answer
pra saw
233 Points
stuck

Posted March 20, 2019 11:29am by pra saw

pra saw
233 Points
1 Answer
Zoe Dadian
177 Points
im not sure what Im doing wrong here

Posted March 11, 2019 3:17am by Zoe Dadian

Zoe Dadian
177 Points
1 Answer
Tevin Muparadzi
1,724 Points
From the users table, find all the username fields with the last_name of "Chalkley". Only return the usernames.

Posted January 13, 2019 4:22am by Tevin Muparadzi

Tevin Muparadzi
1,724 Points
1 Answer
arjunyad
Python Web Development Techdegree Student 444 Points
i don't understand

Posted December 25, 2018 8:24am by arjunyad

arjunyad
Python Web Development Techdegree Student 444 Points
2 Answers
Rhea Khanna
2,838 Points
I do not understand the concept of WHERE (column, operator and value is put)

Posted October 14, 2018 2:40pm by Rhea Khanna

Rhea Khanna
2,838 Points
2 Answers
Fairooz Adams
2,704 Points
Can't get this to work!

Posted September 5, 2018 9:14pm by Fairooz Adams

Fairooz Adams
2,704 Points
1 Answer
yan wang
2,449 Points
Select Query

Posted July 25, 2018 2:06pm by yan wang

yan wang
2,449 Points
1 Answer
PLUS

Jonathan Pina
Courses Plus Student 157 Points
From the users table, find all the username fields with the last_name of "Chalkley". Only return the usernames.

Posted June 21, 2018 10:44am by Jonathan Pina

Jonathan Pina
Courses Plus Student 157 Points
2 Answers
Susan Thatcher
1,217 Points
My code: SELECT username FROM user WHERE last_name= "Chalkley"; It's not working.

Posted June 17, 2018 10:13pm by Susan Thatcher

Susan Thatcher
1,217 Points
2 Answers
adam woolf
1,181 Points
there is a bug here. i believe my syntax is correct

Posted June 12, 2018 12:35am by adam woolf

adam woolf
1,181 Points
1 Answer
Nosin mahbub
664 Points
From the users table, find all the username fields with the last_name of "Chalkley". Only return the usernames

Posted June 3, 2018 7:30pm by Nosin mahbub

Nosin mahbub
664 Points
1 Answer

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