query to replace null value with value of other column mysql code example
Example: replace null value within column mysql
UPDATE `table` SET `somefield`=0 WHERE `somefield` is null
UPDATE `table` SET `somefield`=0 WHERE `somefield` is null