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: 757 days ago
Questions and answers:
Select n/a if catg is NULL
- a) IFNULL(catg, 'n/a')
- b) IF(catg IS NULL, 'n/a')
Select n/a if catg is NULL
- a) IFNULL(catg, 'n/a', catg)
- b) IF(catg IS NULL, 'n/a', catg)
