I have a table where one of the fields can be empty. I'm trying to return only these rows where this field is empty. Any ideas ?

Answer 1

Ok. Now instead of putting WHERE field = NULL
put WHERE field IS NULL;

It should work now.

Answer 2

Ok. Now instead of putting WHERE field = NULL
put WHERE field IS NULL;

It should work now.
https://www.w3schools.com/sql/sql_null_values.asp

Answer 3

I think you should use: SELECT column_name FROM table_name WHERE column_name = NULL;
I'm not sure if it will work, but give it a try.

Answer 4

thank you for your awnser. But I keep getting errors just doing WHERE field = "" ... WHERE field = '' ... WHERE field = null

Answer 5

thank you very much for your help.

Answer 6

hiii

Answer 7

hiii

Answer 8

hi

Answer 9

yes

Answer 10

hi :)