Save up to $499! Grab all Python courses for$49 or all online courses we’ve ever launched for only \$169. Only Feb 11-16. Happy Valentine's!
See the whole table
Select some columns
Filtering rows
Logic
Text patterns
To be or NULL to be
18. Looking for NOT NULL values
A little bit of mathematics
Let's practice

## Instruction

In every row, there can be NULL values, i.e. fields with unknown missing values. Remember the Opel from our table with its missing price? This is exactly a NULL value. We simply don't know the price.

To check whether a column has a value, we use a special instruction IS NOT NULL.

SELECT
id
FROM user
WHERE middle_name IS NOT NULL;


This code selects only those users who have a middle name, i.e. their column middle_name is known.

## Exercise

Select all cars whose price column isn't a null value.

### Stuck? Here's a hint!

Type:

SELECT
*
FROM car
WHERE price IS NOT NULL;