FAQ: Queries - Like II

Frequently Asked Questions SQL FAQ
1

Community%20FAQs%20on%20Codecademy%20Exercises
Community%20FAQs%20on%20Codecademy%20Exercises1000×208 141 KB

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!

2

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
3

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
4

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

:slight_smile:

5

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

6

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

7

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

8

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”.

9

You can use _
(underscore)

SELECT *
FROM films
WHERE title LIKE '100_' ;
1 Like
10

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

1 Like