How to select empty fields where null is set to "no" and default is set to "none"

Question

So there is some target_field which has no default and can't be null how do you select all rows where this field is empty i.e. unpopulated?

SELECT * FROM some_table WHERE target_field ???

in my case the field is of type varchar(100)

Answer 1

try this?

select * from some_table where target_field = ''