Example
Set a default value to cover fields that are NULL.
SELECT <span class='keyword_code'>IFNULL</span>(catg, 'n/a') FROM catg
-> n/a
SELECT <span class='keyword_code'>IF</span>(catg IS NULL, 'n/a', catg) FROM catg
-> n/a
Last update: 244 days ago