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 trial

Databases

Posted by ian kee
ian kee
Courses Plus Student 467 Points

How would i correct this code

We have an e-commerce database. Inside the users table we have the columns of id, username, password, first_name and last_name. Without using the OR keyword, find all the users with the username of "2spooky4me" or "beard_man".

SELECT * username FROM users WHERE username in ("2spooky4me, beard_man");

1 Answer

Wade Williams
Wade Williams
24,476 Points
Wade Williams
Wade Williams
24,476 Points

I think you're just missing some quotation marks:

("2spooky4me, beard_man") should be ("2spooky4me", "beard_man")

All together

SELECT * username FROM users WHERE username IN ("2spooky4me", "beard_man");
Christian A. Castro
Christian A. Castro
30,501 Points
Christian A. Castro
Christian A. Castro
30,501 Points

ian kee Most likely you already answered this question, but for further reference the proper answer is:

SELECT * FROM users WHERE username IN ("2spooky4me", "beard_man");

Wade Williams Have in mind that you need to retrieve all usernames within the table..

I was just happening issues completing that challenge a bit ago.