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 Jesus Vielma
Jesus Vielma
311 Points

Now we're in the e-commerce database. In the users table we have the columns id, username, password, first_name and last

Now we're in the e-commerce database. In the users table we have the columns id, username, password, first_name and last_name.

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

1 Answer

Carlos Federico Puebla Larregle
Carlos Federico Puebla Larregle
21,074 Points
Carlos Federico Puebla Larregle
Carlos Federico Puebla Larregle
21,074 Points

You have to find all the rows where the condition is "true", so you select all from the users table where the column "last_name" is equal to those names. You could do it like this:

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

I hope that helps a little bit.

Jesus Vielma
Jesus Vielma
311 Points

it helps a lot...Thanks