MemoryRefresh!

Query / If null     If null



Questions Answers 0%

Pages   0 from 12
Questions   0 from 14

Reset


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

Related Pages

Order by rand
Concat fields
Select search
Regexp
If null
Union


0% 100%
 
 
0 pages 12 pages
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





Programming

Php
   
Regex
   
MySQL
   
Css
   
jQuery
   
Git
   


References
n/a