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?

2 Likes

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

SELECT *
FROM movies
WHERE name LIKE ‘The %s’

:slight_smile:

Hi,
Can you show the difference between A% and A % in LIKE II?
Thanks!

Hi,
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.