FAQ: Queries - And

This community-built FAQ covers the “And” exercise from the lesson “Queries”.

Paths and Courses
This exercise can be found in the following Codecademy content:

Web Development
Data Science

Learn SQL

FAQs on the exercise And

Join the Discussion. Help a fellow learner on their journey.

Ask or answer a question about this exercise by clicking reply (reply) below!

Agree with a comment or answer? Like (like) to up-vote the contribution!

Need broader help or resources? Head here.

Looking for motivation to keep learning? Join our wider discussions.

Learn more about how to use this guide.

Found a bug? Report it!

Have a question about your account or billing? Reach out to our customer support team!

None of the above? Find out where to ask other questions here!

While doing this exercise I was able to use…

AND genre IS ‘horror’;

instead of

AND genre = ‘horror’;

Are those interchangable?

1 Like

Is the query case-sensitive? How do you structure the query where it will search “Horror” and “horror” in genre?

‘…’ anything in ‘single quotation’ will be case sensitive. It is my understanding that a query will only search for case specific characters with in ‘single quotation’.

Is ‘=’ and the ‘LIKE’ has the same purpose in SQL?