Change a Column’s Value to NULL

To set a column value to NULL, use the update statement.

set column_name = {expression | null}
[, column_name = {expression | null}]...

For example, to find all rows in which the title_id is TC3218 and replace the advance with NULL:

update titles 
set advance = null 
where title_id = "TC3218"