MYSQL Null Empty IsSet

Question

There is a field called image_src in my table. I would like to get something like a boolean value of 1 if the field contains something ( not null or empty ) else 0 other wise. So is there any function to do that? In PHP we have isset()

Something like :

Select isset(image_src) from table

Answer 1

Take a look here:

SELECT if(image_src is null OR image_src = '', 0, 1) FROM table

This line will check if the field is null or empty.

Answer 2

MySQL has the isnull function.