Is this a too simple query

[Mailman]

Hi all, I'm trying to get a result from a simple query. Unfortunatly the result did not come.

Here is the problem:

Say I have a table with 20 records, each of those 4 queries should return 5 records, but only 1 did. 5 records had no value for field1, 5 records had no value for field2, 5 records had no value for field1 and field2 and finally 5 records had value in field1 and field2.

select * from table where field1 = ''
select * from table where field2 = ''
select * from table where field1 = '' and field2 = ''
select * from table where field2 <> ''

The last query return me 5 records. All other queries return 0 row no error ???

Note:field1 and field2 are of type varchar

What did I miss I'm clue less

Thanks to anyone that can help!

[Technosailor]

I really need to see the table and if possible the data...

[frezno]

As Sketch already mentioned it would be necessary to see table and data.
My guess is there's a (default) value for those fields,
therefor they are not empty and you get a result only with checking them <> ''

[Mailman]

the table is created from a php script and declared as following.

field1 varchar(50) null,
field2 varchar(50) null

There is no default value, but you open my mind when you talk about default value. The following query works

select * from table where (field1 is null or field1 = '') and (field2 is null or field2 = '')

Thanks so much guys!

[frezno]

well, there's a difference between NUL(L), 0 and empty