if is not null mariadb procedure code example

Example: mariadb cast null to 0

SELECT COALESCE(col, 0) FROM `table`;