ExpertRefresh

Query / If null  

Related Pages

Order by rand
Concat fields
Select search
Regexp
If null
Union
Using syntax
Ucfirst


0.0% 100%
 
 
0 pages 19 questions
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


References



n/a