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 Stephanie Roberts
Stephanie Roberts
16,757 Points

SQL Basics challenge not working?

Find all users with either the last name "Hinkley" or "Pettit"

I have put SELECT * FROM users WHERE last_name = "Hinkley" OR "Pettit";

It's saying this is wrong. Can someone tell me how please?

2 Answers

Jeff Lemay
Jeff Lemay
14,268 Points
Jeff Lemay
Jeff Lemay
14,268 Points

You can go one of two routes:

SELECT * FROM users WHERE last_name="Hinkley" OR last_name="Pettit";

SELECT * FROM users WHERE last_name IN ("Hinkley", "Pettit");
Stephanie Roberts
Stephanie Roberts
16,757 Points
Stephanie Roberts
Stephanie Roberts
16,757 Points

Oh thanks Jeff, I didn't realise I had to mention last_name twice for each name.