Date: 12/17/05 (MySQL Communtiy)    Keywords: no keywords

Help! I'm a bit confused over how to set a value to NULL.

If I have a string ('NULL') that I want to convert to NULL, is this correct?
UPDATE table SET column = NULL WHERE column = 'NULL'

What about if it's an empty string?
UPDATE table SET column = NULL WHERE column = ''

Sorry if this is terribly silly. TIA. :)

Source: http://www.livejournal.com/community/mysql/77690.html