ExpertRefresh

If null

1) Select n/a if catg is NULL




2) Select n/a if catg is NULL






Set a default value to cover fields that are NULL. Example SELECT IFNULL(catg, 'n/a') FROM catg -> n/a SELECT IF(catg IS NULL, 'n/a', catg) FROM catg -> n/a