MYSQL field is empty?

[Weirfire]

Is it possible to run a query to return all results where a certain field is not empty?

[JoeO]

sure !=NULL or !="" ... depending on how its empty

[Weirfire]

I just read on another forum this solution

SELECT * FROM table_name WHERE column_name > '';

for those who come across this thread in the future.


Thanks JoeO :)

[digitalpoint]

ISNULL([columnname]) is a good operator in MySQL as well.

[Weirfire]

ISNULL([columnname]) is a good operator in MySQL as well.

So to use that for my problem could you put

SELECT * FROM table_name WHERE !(ISNULL([columnname]));

[digitalpoint]

Probably just easier to do this:

SELECT * FROM table_name WHERE NOT ISNULL([columnname]);

[Weirfire]

Cheers Shawn :)