FAQ: Queries - Like I

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

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!

3

does the result different between using capital letters and small letters?
how can i get different results?

2 Likes
7

If I want to search for names in a table that don’t start with a certain letter (i.e B), than how should i use the LIKE operator?

I tried this:

select * from table
where name like != ‘B%’ ;

Doesn’t work!

1 Like
8

I think you can try WHERE name NOT LIKE ‘B%’;

10

LIKE I. Case insensitive search.
How can i do case insensitive search by text in the column ?
For example i need to find all movies LIKE ‘Se_en’. But i want in me result: ‘SevEn’, ‘sEvEn’, ‘seven’, ‘Se7EN’, and so on.
Tank you.

11

when using LIKE function , you cant put = sign in it.

12

Is LIKE case-sensitive?