Looking for correct term for is null string

[kupe]

These won't persuade mysql.

UPDATE table SET label = 'margarine' WHERE label = ' ';

UPDATE table SET label = 'margarine' WHERE label IS NULL;

UPDATE table SET label = 'margarine' WHERE LENGTH(label) <=1;

Be grateful to know what will.

 

[ericbrunson]

All those are perfectly valid SQL DML statements. If they aren't doing what you think they should, then I think the label is not set to what you think it is.

 

[kupe]

Thanks, Eric. You're right - of course. Too much haste and I overlooked something incredibly simple. Sorry. Cheers