Code Forums - View Single Post

sde · 02-19-2006, 11:28 PM

hmm .. can you set the default to NULL? then with mysql, you can check with:

Code:

select * from table where mytextfield is NULL

alternatively, if there was no default null set, and you wanted to query for the text fields that have no data, you could do this:

Code:

select * from table where mytextfield = ''

i don't know what exactly you are trying to accomplish, but give me more info if i didn't help. sometimes taking a step back and re-evaluating how you are trying to accomplish what you need to do helps.

02-19-2006, 11:28 PM	#2 (permalink)
sde Moderator Join Date: May 2002 Location: us.ca Posts: 4,505	hmm .. can you set the default to NULL? then with mysql, you can check with: Code: select * from table where mytextfield is NULL alternatively, if there was no default null set, and you wanted to query for the text fields that have no data, you could do this: Code: select * from table where mytextfield = '' i don't know what exactly you are trying to accomplish, but give me more info if i didn't help. sometimes taking a step back and re-evaluating how you are trying to accomplish what you need to do helps.