MySQL....what is the default default value for a field?
I hope this isn't a dumb question. You can set a default value for all variables or a function for when it is inserted. but if the field is not required to insert and you don't allow null values, what is the "blank" value that you see in phpMyAdmin? in a query is it returned as empty string, etc? 

just trying to figure it out, I want to query for all records such that the value for a specific column in that record is not "empty" or blank or whatever. 

thanks.
MySQL....what is the default default value for a field?
===

I hope this isn't a dumb question. You can set a default value for all variables or a function for when it is inserted. but if the field is not required to insert and you don't allow null values, what is the "blank" value that you see in phpMyAdmin? in a query is it returned as empty string, etc? 

just trying to figure it out, I want to query for all records such that the value for a specific column in that record is not "empty" or blank or whatever. 

thanks.