14,970
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
→check if field value was not fulfilled: NULL, empty value
| Line 175: | Line 175: | ||
=== check if field value was not fulfilled: NULL, empty value === | === check if field value was not fulfilled: NULL, empty value === | ||
{{exclaim}} NOT include those data which its field value fulfilled with default value automatically | {{exclaim}} NOT include those data which its field value fulfilled with default value automatically ([http://sqlfiddle.com/#!2/9b01e/3/0 demo on sqlfiddle]) | ||
# {{Gd}} quick solution: find records with {{kbd | key = NULL}} value OR empty, space value | |||
#* MySQL solution: {{kbd | key = SELECT * FROM table_name WHERE column_name IS NULL OR LENGTH(TRIM( column_name )) = 0;}} | |||
# find records with {{kbd | key = NULL}} value: (note: not {{kbd | key = #NULL!}}) | # find records with {{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;}} | ||