change value to null mysql code example
Example 1: mysql set value as null
UPDATE table SET field = NULL WHERE something = something
Example 2: replace null value within column mysql
UPDATE `table` SET `somefield`=0 WHERE `somefield` is null
UPDATE table SET field = NULL WHERE something = something
UPDATE `table` SET `somefield`=0 WHERE `somefield` is null