Whats wrong in my query??

Question

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"

my query is :- SELECT * FROM users WHERE last_name = "Hinkley" OR "Pettit";

can someone help with what's the mistake in my query?

Answer 1 · 2017-01-15T16:38:29Z

January 15, 2017 4:38pm

You can only combine complete comparisons.

So instead of this:

... last_name = "Hinkley" OR "Pettit"

You'd need something more like this:

... last_name = "Hinkley" OR last_name = "Pettit"

And another way to do it, but this may use a feature that hasn't been introduced yet, would be like this:

... last_name IN ("Hinkley", "Pettit")

For any future questions please include a link the the course page you are working with.

Answer 2 · 2017-10-22T01:55:59Z

October 22, 2017 1:55am

SELECT * from users WHERE last_name = "Hinkley" OR last_name = "Pettit"

Welcome to the Treehouse Community

Looking to learn something new?

Arun Kumar

Arun Kumar

Whats wrong in my query??

2 Answers

Steven Parker

Steven Parker

You can only combine complete comparisons.

Arun Kumar

Arun Kumar

Michael Wallace

Michael Wallace

Damion Samuels

Damion Samuels

Steven Parker

Steven Parker