Check if a MySQL query returns an empty result.

2 years ago

Liam

1 minute

In MySQL, you can use IS NULL or IS NOT NULL to determine if a field is empty.

Here is an example:

SELECT * FROM table_name WHERE column_name IS NULL;

This statement will return all records in the table where the column_name field is empty.

SELECT * FROM table_name WHERE column_name IS NOT NULL;

This statement will return all records in the table where the column_name field is not empty.

Also, if you want to add a new column to the query results to indicate whether a field is empty, you can use the IF function.

SELECT *, IF(column_name IS NULL, 'Yes', 'No') AS is_empty FROM table_name;

This statement will add a column named is_empty to the query results, which will display ‘Yes’ if the column_name field is empty, otherwise it will display ‘No’.