FAQ: Queries - Like II

This community-built FAQ covers the “Like II” 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 Like II

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!

Is there a way to search for patterns with a specific case. For example, “The” as opposed of “the”.
In RegEx we can use (?i).
Is it possible with SQL?


How do we get result for pattern which start and ends with certain character. For example lets say i want results which start with ‘The’ and end with ‘s’

1 Like

FROM movies
WHERE name LIKE ‘The %s’


Can you show the difference between A% and A % in LIKE II?

I would like to know what is the difference between “The%” and “The %”. Does the space in between do anything significant? Thanks!

Yes. “The%” can display words like “There”, but “The %” can’t.

Hi, what happens if you want to search for something that has a % sign in it’s title? Do you need to find an alternative operation? For example for these made up movies titles: “I 100% agree” and “The 80% rule”.

You can use _

FROM films
WHERE title LIKE '100_' ;
1 Like

Ahh - that’s good to know! Thank you so much.

1 Like