13,468
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
→check if field value was not fulfilled: NULL, empty value
| Line 15: | Line 15: | ||
([http://sqlfiddle.com/#!2/9b01e/3/0 demo on sqlfiddle]) | ([http://sqlfiddle.com/#!2/9b01e/3/0 demo on sqlfiddle]) | ||
# {{kbd | key = NULL}} value: | # {{kbd | key = NULL}} value: (note: not {{kbd | key = #NULL!}}) | ||
#* MySQL solution: {{kbd | key = SELECT * FROM table_name WHERE column_name IS NULL;}} | #* MySQL solution: {{kbd | key = SELECT * FROM table_name WHERE column_name IS NULL;}} | ||
#* EXCEL: {{kbd | key =<nowiki>=EXACT(A2, "NULL")</nowiki>}} | #* EXCEL: {{kbd | key =<nowiki>=EXACT(A2, "NULL")</nowiki>}} | ||