How to Filter with the WHERE clause in SQL

Filter your SQL table for the information you need by using the WHERE clause!

Queries using WHERE:
1) Filter your query based on an exact match: SELECT * FROM table WHERE column='value'
2) Filter your query using Wildcards to match a pattern: SELECT * FROM table WHERE column LIKE '%str%ing%'
3) Filter your query using numeric operators: SELECT * FROM table WHERE column < 5
4) Beef up your filters by using the AND & OR statements: SELECT * FROM table WHERE (column1 < 5 AND column2 LIKE '%a%') OR column3 = 1
5) Exlude info from you query using the NOT clause: SELECT * FROM table WHERE NOT column1 = 1
6) Pull a range of information using the BETWEEN clause: SELECT * FROM table WHERE column1 BETWEEN 1 AND 5
7) Extract all the NULL or NOT NULL values out of your table: SELECT * FROM table WHERE column1 IS NULL

Support the Channel:

[aniknohan]

You’re amazingly awesome. Love the way you teach SQL. You make everything simplest possible.

[rainnedaze]

So glad I found this. This is so direct and clear. Thank you!

[NinaTucker]

Just subscribed thank you for all your information you break it down so well

[b.sanjay]

Very Important topics SQL for data science learn

[nyleahmed]

1 MILLION TIMES BETTERTHEN MY TEACHER AT SCHOOL

[ImranKhan-ftns]

Thank you so much for the clear explanation.

[therugbaddie]

you are helping so many people, thank you!

[ManojKumar-zngf]

For example country column is holding some country names like USA, UK, India, Australia and some Null values, In my case I need to filter country name 'USA' and fields which is 'NULL' in single where condition. Does there is any other way to filter these condition. Pls let me know answer to this question. Note: Null is not a value in that country column.

[JackieShroffFan]

Thank you so much for your help. I was struggling with the WHERE statement (filter data by listing all managers). In my case it was listing all movies released in January, February etc. Thanks again God Bless 😇👍

[IamNagendra_yadav]

you're amazing one video is enough for WHERE clause

[ff]

Hi

What will happen if we have a select query with multiple conditions in where clause (mix of equal to, not equal to, between, greater than, less than) with and/or without parentheses?

Will it fetch correct results?

Please let me know.

Thank you!

[davidlewisn]

Hello, could i get help on how to join 5 tables please.David

[dejasbeautyxoxo]

This was beyond helpful thank you so mcuh!!!

[teawithcinnamon]

Thank you! This playlist is very helpful.

[Prettybyale]

Thank you so much for your video! they are easy and you get straight to the point :)

[haseebasif]

Its really great and underrate video, thanks alot

[TheFallonCarrington]

I just want to say thank you so much for this

[Larva]

I like your videos and I think they are a good choice for those who have the basic idea. Have you considered giving some practices at the end of the video or a video full or practices with the answer?

[beingfijian]

Great video, please keep making more. they are very helpful!

[mulugetakebede]

Thank you brother, this is so helpfull