Need help with simple MySql question

[rob76]

Simple question

I'm want to return a set of results from mysql where the fields are empty. I've tried the following to look for empty strings but it returns no results even though there are plenty of records that have no data in 'field'. I have the data type set to varchar(50) Null

SELECT * from table where field=''

What does a field actually contain when it has no data in it?

Please could someone point me in the right direction

Thanks Rob

[Drakla]

You can use the field='' for somethings, but you can give

SELECT * from table where field IS NULL;

A go

[rob76]

That worked - Thanks very much

Rob