Modules

Hey, so you're working with SQL and stumbled upon this thing called "IS NULL", right? Let me break it down for you.

In SQL, sometimes you've got tables with empty spots, like cells with absolutely nothing in them. It's a bit different from Excel, where an empty cell and a cell with just a space kind of mean the same thing. But in SQL, it's a big deal because these empty spots (or 'null values') can mess with your data and queries.

Here's the kicker: if you want to find these empty spots in a specific column, you use "IS NULL". It's like a detective tool that helps you spot the blanks. So, if you're looking at, say, a music chart dataset and want to find all entries where the artist's name is missing, you'd do something like this:

SELECT *
FROM some_music_chart
WHERE artist IS NULL;

But hey, don't try using "WHERE artist = NULL". That's a no-go. SQL gets confused and thinks you're trying to do math with something that doesn't exist. Just stick with "IS NULL" to find those empty cells, and you should be good!

This concept of IS NULL will be so useful when we will start covering JOINs so keep that in mind! Now let's do a quick practice 😍