minte9
LearnRemember / MYSQL



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 
    






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)


References