+ 3

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 ?

10th May 2017, 2:20 PM
Ramin Bagherian
Ramin Bagherian - avatar
10 Respostas
+ 5
Ok. Now instead of putting WHERE field = NULL put WHERE field IS NULL; It should work now.
10th May 2017, 3:39 PM
Ulisses Cruz
Ulisses Cruz - avatar
+ 4
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
10th May 2017, 3:39 PM
Ulisses Cruz
Ulisses Cruz - avatar
+ 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.
10th May 2017, 3:22 PM
Ulisses Cruz
Ulisses Cruz - avatar
+ 2
thank you for your awnser. But I keep getting errors just doing WHERE field = "" ... WHERE field = '' ... WHERE field = null
10th May 2017, 3:34 PM
Ramin Bagherian
Ramin Bagherian - avatar
+ 2
thank you very much for your help.
10th May 2017, 11:27 PM
Ramin Bagherian
Ramin Bagherian - avatar
+ 1
hiii
25th May 2017, 10:28 PM
Shanta Soren
Shanta Soren - avatar
+ 1
hiii
1st Jun 2017, 2:11 PM
Shanta Soren
Shanta Soren - avatar
0
hi
26th May 2017, 5:05 AM
Ramin Bagherian
Ramin Bagherian - avatar
0
yes
28th May 2017, 7:40 AM
Shanta Soren
Shanta Soren - avatar
0
hi :)
1st Jun 2017, 2:18 PM
Ramin Bagherian
Ramin Bagherian - avatar