how to show n/a instead of null in mysqli using php code example

Example: replace null value within column mysql

UPDATE `table` SET `somefield`=0 WHERE `somefield` is null