Checking if stored value is NULL?

Hi there,

I am trying to write a script that checks if a value in a MySQL database has a value or not.
I’ve tried “empty”, “is_null”, etc… But nothing is working.

How can I determine whether or not a value in a database has a value other than ‘’ (nothing)?

Eric Johnson

SELECT * FROM tbl WHERE somecolumn IS NULL

Thanks for the quick reply Jay.P!

But I actually figured it out… Just a simple syntax error. :lol: