MySQL Query Non-Empty Fields: IS NOT NULL

1 year ago
Liam
1 minute

In MySQL, you can use IS NOT NULL to query records where a field is not empty.

For example, let’s say we have a table called users with a field called email representing the user’s email address. If we want to query all users with a non-empty email address, we can use the following SQL statement:

SELECT * FROM users WHERE email IS NOT NULL;

This will return all records in the users table where the email field is not empty.

bannerAds