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